Databases - Compacting Tables

Some database systems are very inefficient. They seem to excel at wasting space.

Paradox | MS Access | Delphi | Visual Basic | Java


MS Access 97

From the menu, select
mdb File Initial
Contacts.mdb 1,236,992 258,048
DeliveryOrders.mdb 2,103,296 358,400
Items.mdb 8,992,768 2,156,544
MainLibrary.mdb 1,157,120 196,608

By watching as MS Access compacted a file on a floppy, it appears that Access copies the mdb file to a second file, deletes the original file, and then re-names the new file. (For files on the hard drive, Access is too fast to see the temporary file.)

Delphi 5.0

Visual Basic 6.0


Author: Robert Clemenzi -
URL: http:// / user / clemenzi / technical / Databases / CompactTables.html