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