Stephen Chrzanowski wrote: > On Thu, Aug 29, 2013 at 3:03 AM, Clemens Ladisch <clem...@ladisch.de> wrote: >> 3. auto_vacuum will increase fragmentation > > I thought it did a complete dump to a new file?
<http://www.sqlite.org/pragma.html#pragma_auto_vacuum> says: | Auto-vacuum does not defragment the database nor repack individual | database pages the way that the VACUUM command does. In fact, because | it moves pages around within the file, auto-vacuum can actually make | fragmentation worse. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users