Security Overhead

Does anyone have experience with performance impact when one has lots of rows in F00950 Security Workbench? We are talking about adding to our 250000 records with security on each object.

I wonder if more memory per client (say in a WTS environment) is used when this info is loaded into JDE cache.

AS400 V5R1, XE+XU1+45ESUs, SP16, NT-SQL7 for CO

We've got almost 400,000 records in our security table - a lot of it is row
security. If Inclusive row security had come out a few months earlier we
would have half the number of records that we have now.

We did have to make some performance changes since with this many records it
tool about 15 - 30 seconds to login (due to user level row security)

1. In TDA add an index for UserId. This way if you use user level security
the system won't do a full table scan everytime a use logs in. This cut our
login time to 2 seconds.

2. Database optimization. We changed the Storage parameters on the F00950.
We had to do this from within P9861151 (Work with Table and Data Source
Sizing) in order to maintain the changes in Oracle.

Index Initial Storage 5242880
Index Next Storage 5242880
Index Min Extent 1
Index Max Extent 99

3. More Database optimization. See JDE document oti-00-0148. Update
Statistics really improves performance.

We noticed performance improvements on both FAT and TSE.

Colin

B733.2 SP17.1_H1
Intel/NT/Oracle 8.1.7.1