Here I am looking what is best strategy sqlite3 provide for database purging.What combination of auto vacuum & vacuum to be used?
I have started using sqlite from few weeks so answer from experience will help me. On Thu, Aug 29, 2013 at 12:33 PM, 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