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