Kbase P43351: Progress 9.1D07 service pack provides enhanced reindex build performance.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
GOAL:
Progress 9.1D07 service pack provides enhanced re-index build performance.
GOAL:
How to increase performance using idxbuild?
FACT(s) (Environment):
Progress 9.1D
UNIX
Windows
FIX:
The Progress 9.1D index rebuild utility has been improved to decrease the time required to rebuild indexes. 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. It is used to specify the number of sort groups. Previously, this value was fixed at 8. Possible values are now 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. The amount of memory required for buffers is calculated as follows:
(number of sort groups) * (-TB value) * (-TM value + 1) kilobytes.
For example, with settings of -SG 48, -TB 32 & -TM 16 approximately 26 megabytes of memory will be required.
* This release of the index rebuild utility requires approximately the same amount of disk space for sorting and merging as the previous Progress versions.
* This release of the index rebuild utility uses more temporary files than the previous version. A set of temporary files may be opened per each sort group for each entry specified within the file that identifies the size and location of the temporary files used during index rebuild (i.e. the multi-volume SRT file). For example, if the previous release used 10 temporary files, this release, with a default setting of -SG, will use 480 temporary files.