SQLite Database Gets Bigger After Vacuum

Question

As part of updating some of the client records in my sqlite database, I deleted the load of records and then imported some of the imported table. Then I deleted the temporary table and made a vacuum. The file was about 6 mb in front of the vacuum cleaner, and then 10 mb after evacuation. I did an integrity check, and everything is fine. I did another test, and if I do not evacuate, the file size is still about 6 mb.

Am I doing something wrong?

(I deal with vacuum using SQLite Manager. However, when using SQLiteSpy it works correctly, so it seems to be a problem with SQLite Manager. Perhaps this will be useful for those who have a similar problem)

Answer 1

This is a bug with SQLite Manager. See my comments in the original post. Works when using another tool such as SQLiteSpy.