Kbase P117036: How to use IDXBUILD with threads in version 10.1A or later.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
24/03/2009 |
|
Status: Verified
GOAL:
How to use IDXBUILD with threads in version 10.1A or later.
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1x
FIX:
IDXBUILD in version 10.1A and later has been architected to use threads on a system with multiple CPUs to optimize builds / sorts with more than 1 index simultaneously.
If the Enterprise Database license is installed IDXBUILD will now use threads by default i.e. the -thread parameter will be silently set to 1 (indicating threads will be used) and -threadnum will be set to <# of processors>.
Higher improvements to speed using threads are expected only when simultaneously building a number of indices.
The standard advisements still apply with regards to I/O contention and database design.
i.e.
Reduce contention by performing any index sorting on disks separate from the database files.
Put indices in their own areas (if possible use Type II areas) to reduce the number of blocks that need to be scannned / modified during the idxbuild.