On Fri, Oct 28, 2011 at 5:36 AM, Jay A. Kreibich <j...@kreibi.ch> wrote: > On Fri, Oct 28, 2011 at 01:33:31PM +0200, Gert Corthout scratched on the wall: >> we have a database that only performs insert statements on a table >> (database contains only this table), is it in this case a good idea >> to reduce the cache size to, say, 5? > > No, that would be a bad idea. Smaller than the default 2000 might > work, but you don't want to go that small.
What Jay said. I just wanted to additionally point out that making the cache absurdly small gets into diminishing returns. If you drop to 100 you've already saved 95% of the potential cache size already (though you might not have cut the ACTUAL usage that much). -scott _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
