Kbase P46614: How to make idxbuild faster (starting with 9.1D07)?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/12/2002 |
|
Status: Unverified
GOAL:
How to make idxbuild faster (starting with 9.1D07)?
FIX:
As part of fix for bug# 20020206-028 (idxbuild taking longer in V9 than in V8), a new parameter has been introduced, "SG", for specifying the number of sort groups used during idxbuild.
Taking advantage of the fix is explicitly adding the new -SG parameter on idxbuild, described within all 9.1D07 READMESP file.
See below the relevant extract from 9.1D07 README.SP.
Enhanced Performance of Index Rebuild Tool
-----------------------------------------------
Performance of the Index Rebuild Utility has been improved to decrease
the time required to build indexes for tables in the Progress RDBMS.
Results will vary depending on database size, number of indexes, and
operating system.
The following enhancements have been made:
* There is a new startup parameter for building indexes: -SG, which you
use to specify the number of sort groups that will be used. Previously
this value was fixed at 8. Possible values are 8 through 64, inclusive.
The default value is 48.
* The index rebuild utility allocates more memory for sorting and
merging. This additional memory reduces the elapsed time required for
sorting and merging key values. In this release, amount of memory
required for buffers is:
(number of sort groups) * (-TB value) * (-TM value + 1) kilobytes.
With settings of -SG 48 -TB 32 -TM 16, approximately 26 megabytes of
memory will be required for sort-merge buffer space.
* This release of the index rebuild tool requires approximately the same
amount of disk space for sorting and merging as the previous version.
* This release of the index rebuild tool uses more temporary files than
the previous version. A set of temporary files may be opened for each
sort group for each entry in the file that specifies size and location of
scratch files used by index rebuild. Thus an index rebuild that previously
required 4 scratch files will use up to 32 scratch files when -SG is set to
8.
===========================================================================