CODEWITHSUNDEEP
sqlite
alj
alj

Reputation: 3039

SQLite database gets larger after vacuum

As part of refreshing some of the customer records in my sqlite database, I deleted a load of records and then imported some from an imported table. I then deleted the temp table and did a vacuum. The file was around 6mb before vacuuming and then 10mb after vacuuming. I did an integrity check and it seems ok. I did another test and if I don't vacuum, the file size is still about 6mb.

Am I doing something wrong?

(I've been doing the vacuum using a SQLite Manager. When using SQLiteSpy, however, it works properly. So it seems to be a problem with SQLite Manager. Might be of use to someone who has a similar problem)

Upvotes: 6

Views: 1465

Answers (1)

alj
alj

Reputation: 3039

It's a bug with SQLite Manager. See my comments in the original post. Works when using another tool like SQLiteSpy.

Upvotes: 6

Related Questions