Performance Improvement when creating indexes

Previous Topic Next Topic
classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view

Performance Improvement when creating indexes

Norm Green-2
Here's a tip that might improve index creation performance:

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

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.