by Teknojnky » Thu Oct 25, 2007 4:15 pm
My understanding is thus:
as records/data is changed/removed, the database becomes larger but never gets smaller...
compacting the database is akin to defragmenting a hardrive;
- a new database file is regenerated without the empty spaces of old removed data, thus reducing the space
- indexes/tables rebuilt and/or verified for consistency etc
- probly other stuff I forgot or don't know
My understanding is thus:
as records/data is changed/removed, the database becomes larger but never gets smaller...
compacting the database is akin to defragmenting a hardrive;
- a new database file is regenerated without the empty spaces of old removed data, thus reducing the space
- indexes/tables rebuilt and/or verified for consistency etc
- probly other stuff I forgot or don't know