How on #3? I thought it did a complete dump to a new file?
On Thu, Aug 29, 2013 at 3:03 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > techi eth wrote: > > When I look through details about PRAGMA auto_vacuum,I think it is always > > beneficial to have auto_vaccum set to Full so that whenever delete > happens we > > have shrink of size. > > > > I wanted to know is their any benefit to have this to none in default > > instead of full. > > 1. backwards compatibility > 2. when data is inserted later, the pages will be reused anyway > 3. auto_vacuum will increase fragmentation > > > 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
