Ahhh.. Thats the difference. Auto_Vacuum versus Vacuum pragmas. doh. Shoulda thought of that. I blame 2am.
On Thu, Aug 29, 2013 at 5:43 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
