Scatter factor

Rob Fitzpatrick Sponsor
If you look at your system object CRUD stats and find that you are doing a lot of reads on schema tables and want to optimize that in some way, then you can add the schema area to the alternate buffer pool to ensure the reads are done from memory, not disk, and without LRU latching (assuming appropriate configuration).
proutil dbname -C enableB2 "schema area" then start the database with an appropriate value for -B2.

That said, this type of change should be far down your list of optimizations if you want to improve overall database performance.


To monitor your schema CRUD activity you should use suggestions for "complete" coverage (this is for a sports2000 database):

Screen Shot 2020-02-07 at 9.30.09 AM.png