defragment/compact

[Ruslan Zasukhin]

On 12/16/05 4:27 AM, "Charles Cohen" <rwc1717 at shaw.ca> wrote:

> Original db size = 2723840
> 
> Defragment/Compact = 2723840
> 
> Dump/Load = 2428928
> 
> Conclusion...is dumping/loading back-to-back advisable
> ie: make a new dumped backup then restore it immediately to effectively
> defragment/compact it?

Defragment -- do not change size. Only order of internal files

Compact -- remove empty segments which you can get after drop field/table.

Dump/Load + Clone -- they removed ALL deleted records, this require
corrections of objectPtr values and links.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]