On 29 Aug 2013, at 9:16am, techi eth <techi...@gmail.com> wrote: > 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.
If you don't do significant deletions from your file (i.e. lots of DELETE FROM instructions) or if you don't care about file size, don't do either. Very few database apps actually do lots of DELETE commands so very few of them have significant amounts of space to recover. If there's a time in your program when you have just done lots of deletion and your users do not need immediate response (perhaps just before your application quits or part of a monthly maintenance operation), do a manual VACUUM at that time. Otherwise use autovacuum. If you are not in a state where you can know the things needed to figure out the above, use autovacuum. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
