Performance Improvement when creating indexes

classic Classic list List threaded Threaded
1 message Options
Norm Green-2 Norm Green-2
Reply | Threaded
Open this post in threaded view
|  
Report Content as Inappropriate
star

Performance Improvement when creating indexes

Here's a tip that might improve index creation performance:

Before creating the index(es), run this code and commit:

doit
IndexManager current dirtyObjectCommitThreshold: SmallInteger maximumValue.
%

This code causes the index manager to do fewer commits while building indexes by having it ignore how many dirty objects it has created when deciding whether to commit.  Instead, it will only commit when object memory is nearly full.  Without this code, it will commit whenever 20000 objects become dirty, which can lead to several commits per second and the extra overhead that comes with them.

Norm



Loading...