Kbase P97798: How a large -B value affects Progress idxbuild
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
14/12/2004 |
|
Status: Unverified
GOAL:
How will a large -B value affects Progress idxbuild?
GOAL:
Will using -B improve an index rebuild process?
FIX:
Index rebuild does not require nor benefit from large -B settings. This is due to the nature of the block access. Most blocks are not visited multiple times and comparatively few blocks are needed in memory simultaneously.
A large -B setting should not be used in single user mode. Index rebuild is a single-user utility that does not use shared memory. Most of the data structures will be allocated in process private memory, in the heap.
There are limitations on how much heap index rebuild and any other single user mode program can use. These limitations are different than the ones that exist in multi-user mode.