Kbase P29088: Is there any downsides of a larger -L then necessary?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
22/01/2005 |
|
Status: Unverified
GOAL:
Is there any downsides of a larger -L then necessary?
FIX:
The -L parameter being set larger then necessary will not cause any problems to the database. The -L parameter sets a ceiling to the amount of locks able to be requested. If the normal day to day transaction do not require a large amount of locks then the amount allocated to the -L parameter will not be used.
The -L parameter allocates the number of locks per a request and does not
allocate them unless they are requested. However for each lock specified by the -L parameter the database engine will reserve 18 bytes of memory per a lock, regardless of whether the lock is used or not.