> On Oct 24, 2016, at 1:31 AM, Rowan Worth <row...@dug.com> wrote: > > OK, so the entire cache is invalidated when another process updates the DB, > which is what I feared. In this case I'm looking at too many concurrent > updates for caching to add much value.
I’m no expert on the internals, but the article linked to says that this counter isn’t used in WAL mode. And with the WAL the main database file is updated less frequently, so the cache might remain valid longer. (Again, I’m just hypothesizing.) If you’re doing a lot of updates, you should probably be using WAL mode anyway. —Jens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
