Databases - Compacting Tables

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

Paradox | MS Access | Delphi | Visual Basic | Java


Paradox


MS Access 97

From the menu, select
mdb File Initial
Size
Final
Size
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


Java


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