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

Reply via email to