Scatter factor

Vinit Bot

New Member
I would like to know if the scatter factor of _file and _field have an effect on performance?
 

Rob Fitzpatrick

ProgressTalk.com 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.
 

TomBascom

Curmudgeon
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
 
Top