On Sep 17, 2010, at 16:08:42 PDT, Oliver Schneider wrote: > just a few minutes ago I ran a VACUUM on a DB file and the size before > was 2089610240 and afterwards 2135066624. Is this normal?
I've recently been noticing the same thing, for example: 443182080 newdb.sq3 $ sqlite3 newdb.sq3 SQLite version 3.6.22 Enter ".help" for instructions Enter SQL statements terminated with a ";" sqlite> PRAGMA freelist_count; 0 sqlite> PRAGMA integrity_check; ok sqlite> vacuum; sqlite> PRAGMA freelist_count; 0 sqlite> PRAGMA integrity_check; ok sqlite> .quit 444920832 newdb.sq3 Admittedly that's only about 0.4% growth in size, but I too was under the impression that vacuum did not grow the database size. Subsequent vacuum commands do not seem to grow the database any further. Kyle _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
