One thing to remember is the the database compression is not compression in the sense that, for example, creating a zip archive compresses files.
To quote from the SQLite documentation:
Quote:
|
VACUUM command cleans the main database by copying its contents to a temporary database file and reloading the original database file from the copy. This eliminates free pages, aligns table data to be contiguous, and otherwise cleans up the database file structure.
|