Kbase P138206: Is there an auto defragmenter for the database?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/12/2008 |
|
Status: Unverified
GOAL:
Is there an auto defragmenter for the database?
GOAL:
Is there an auto-defragmenter for the database?
GOAL:
Does Progress have an automatic defragment utility?
GOAL:
Does OpenEdge have a defragmenter?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1A
OpenEdge 10.2x
OpenEdge 10.1x
FIX:
Yes, it has been in OpenEdge since 10.1A, and is in all subsequent releases. Essentially a record will no longer fragment endlessly. In some instances, for example a record with comments that is updated (with small comments) over a long period of time, it ends up fragmented over something like 800 database blocks.
With the 10.1A change, a 32KB record (largest there could be) will not fragment over more than:
33 blocks for 1KB dblocksize
17 blocks for 2KB dblocksize
9 blocks for 4KB dblocksize
5 blocks for 8KB dblocksize
Also, the enhancement will defrag an existing highly fragmented record into the minimum number of fragments or the minimum number of fragments +1 when the record is next updated. So not only will it prevent the case of 800 fragments as in the situation previously described, it will automatically defragment those 800 fragments into the minimum (+1) fragments based on the record size the next time that record is updated.