Kbase P97487: How to optimize the database block toss and create limits ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2009 |
|
Status: Verified
GOAL:
How to optimize the database toss and create limits for Type I and Type II Areas ?
GOAL:
How to optimize the database at the table level for Type I and Type II Areas ?
GOAL:
How to optimize the database at the BLOB level for Type I and Type II Areas ?
GOAL:
What is the create limit for a database object ?
GOAL:
What is the toss limit for a database object ?
GOAL:
Are there any advanced features for application tuning at table level?
FACT(s) (Environment):
OpenEdge 10.0B
OpenEdge 10.1x
OpenEdge 10.2x
All Supported Operating Systems
FIX:
In OpenEdge 10.0B, a new set of PROUTIL utilities are provided to set and display toss and create limits for table and BLOB objects. Toss and create limit values are specified in Bytes and relate to the amount of free space in a block containing data for a given object.
The "Create Limit" for an object specifies the minimum amount of free space required in a block to allow creation of a new record starting in that block. If the amount of free space in a block is less than the create limit, that block will not be available for creation of new records. The default create limit is 75 bytes for database with a block size of 1Kb; for other block sizes, the default create limit is 150 bytes. Create limit values must be less than or equal to the (block size minus 128) and greater than or equal to 32.
The "Toss Limit" specifies the minimum amount of free space needed in a block for it to remain on the RM Chain. If a block's free space drops below this limit, that block is removed (tossed) from the RM Chain. The effect of this is to reserve the block's remaining free space for expansion of records that are already contained in it. The block will then neither be available for creation of new records nor for expansion of records not already contained within this block. The default toss limit is 150 bytes for database with a block size of 1Kb; for other block sizes, the default toss limit is 300 bytes. Toss limit v