Quote:
Originally Posted by Ken Maltby
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.
|
The SQLite browser will have somewhere to run an SQL statement. You can enter "vacuum" in that and run it. The menu simple is a shortcut to running the statement.
As to why they chose "vacuum" for the name of the statement, I don't know. From my DB2 and SQLServer days, I think of it as "reorganize". "Compress" is a good generic term.