Quote:
Originally Posted by davidfor
Sorry, I'm swapping between different terms for the same thing. "vacuum" is the SQLite statement to compress the database. "Compress" is the more generic term that is used in most other database and in the various menus. Choosing this option will just run the vacuum statement.
|
I an just a little more confused. My non-expert SQLite is using the term "Compact", not "vacuum". The term "compress" is most often related to what the Zip programs do. I would expect a process named "vacuum" to be finding and removing un-needed bits, duplicates and orphans, within the database.
But I don't claim to have any idea how this feature functions in SQLite.
Luck;
Ken