Kbase 13729: Improving performance of idxbuild - index rebuild
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
Improving performance of idxbuild - index rebuild
The following parameters are suggested when doing an index rebuild
with the proutil idxbuild utility with sorting:
Unix format: proutil <dbname> -C idxbuild -TB 24 -TM 32 -B 512
VMS format: PROGRESS/UTILITIES=IDXBUILD dbname /TBLOCKS=31/MERGE_NUM=
32/BUFFERS=512
This should improve performance of the index rebuild.
For sorting, -TB 24 is suggested for UNIX systems because it is a
multiple of 8 and most UNIX file system buffers are 8K.
For merging, the maximum value of 32 is suggested for the -TM
parameter.
See kbase entry 11242 for a detailed description of the sort and merge
parameters, -TB and -TM.
For buffer space, -B 512 should be adequate for all but the largest
database. The default for -B is 20 which is much too low for most
databases if a reasonable speed is desired.
When rebuilding without sorting, specifying -B larger than 512 (the
bigger the better) will improve performance. None of the other
parameters will have any effect on the speed of the index rebuild.
***NOTE*** On very large data bases the -B may cause an error (1040)
not enough database buffers. The work around is to NOT use the -B
parameter at all, if you run into this error. rve-1/29/96
Progress Software Technical Support Note # 13729