Consultor Eletrônico



Kbase P19417: Why can the ai-file growth be much bigger than the respective size of the deleted records?
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   16/10/2008
Status: Unverified

GOAL:

Why can the ai-file growth be much bigger than the respective size of the deleted records?

FIX:

When records are deleted this will be documented as ai-notes in the ai-files (like any modification of data). However, also the respected index entries and other space management operations will be written as ai-notes. Thus, the ai-file growth can be bigger than the size of all deleted records, e.g. in a customer's case up to 7 times bigger.