Kbase P72607: How to run idxbuild the fastest way?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/06/2008 |
|
Status: Verified
GOAL:
How to run idxbuild the fastest way?
GOAL:
What is the quickest way to run an index rebuild.
FACT(s) (Environment):
All Supported Operating Systems
Progress/OpenEdge Versions
FIX:
1. Create a multi-volume sort file. This negates the need to use the -T parameter on the command line and allows sorting to use more than 2GB of space. If possible, allocate the sort directories onto hard drives other than where the database files reside.
2. Use the proutil command like this:
proutil <dbname> -C idxbuild <SOME/ALL> -TB 24 -TM 32 -B 1000
3. If you are using 9.1D07 or higher, you can use an additional parameter called Sort Groups (-SG), like this:
proutil <dbname> -C idxbuild SOME/ALL -TB 24 -TM 32 -B 1000 -SG 64
4. When running through the idxbuild prompts, make sure that you say YES that you have enough disk space for index sorting. If you say NO, then it will run much slower and it will not use the multi-volume sort files either. Don't be fooled into thinking that by saying "NO" to this question that it will sort everything in memory and therefore be faster. Obviously you must ensure that you do in fact have enough disk space for index sorting, which is usually ~75% of the database size but could be more/less.