Scatter factor

[Vinit Bot]

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

 

[Rob Fitzpatrick]

No.

 

[Rob Fitzpatrick]

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]

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