Kbase P15000: Value for -B on single user process
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/16/2008 |
|
Status: Unverified
GOAL:
Value for -B on single user process
FIX:
The best value of "-B" for a single user process is the one which will give the best performance on a specific machine. Testing is the only way to know what is that best value.
However, you can estimate the optimal number of database blocks you would need in the buffer pool at the same time. Knowing how many indexes are used and knowing how many tables are concurrently accessed is a starting point for the calculation. Index blocks are the ones which will certainly reside all the time in the buffer pool as they are the mostly accessed.
It has been seen that an "idxbuild" (one of the options of "proutil") run in single user mode with a value of "-B" higher than 1024 had bad performance due to the overhead of a large buffer pool's management.