Re: [sqlite] Database size bigger than before deleting records

2012-12-03 Thread Henry Huang
Hi Jay, No, auto_vacuuming is off. And yes, the rows are gone, at least i couldn't find them anymore in those tables. My database file is more than 50MB, and I only deleted records in 3 tables. And indeed, there are lots of indexes inside, so maybe you're right. On Sun, Dec 2, 2012 at 10:37

Re: [sqlite] Database size bigger than before deleting records

2012-12-02 Thread Jay A. Kreibich
On Sun, Dec 02, 2012 at 09:39:23PM +0100, Henry Huang scratched on the wall: > Good day everyone, > > I had a database file, and I deleted many records (tens of thousands) from > three tables, then, I did a VACUUM to that database. After I checked the > size of the database file, I was a bit