I'd recommend NONE (or 0). If you have fairly balanced insertions and deletions then there will be no excessive disk space consumption, vacuuming won't help much. But with auto-vacuuming turned on you won't have the same performance because additional code will be executed after each transaction.
Pavel On Tue, May 11, 2010 at 2:50 PM, Joanne Pham <joannekp...@yahoo.com> wrote: > Hi All, > I have the database which has a lot of insertion and deletion. Do you have > any recomendation about what value that need to be set for auto_vacuum > in this case to improve the performance for deletion as well as insertion the > new row to the database. (0 | NONE | 1 | FULL | 2 | INCREMENTAL;) > Thanks, > JP > > > > _______________________________________________ > 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