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

Reply via email to