On 24 October 2016 at 15:44, Clemens Ladisch <[email protected]> wrote:
> Rowan Worth wrote: > > How does sqlite determine that the cached page is out of date? > > http://www.sqlite.org/fileformat2.html#file_change_counter > > > Ultimately the question I'm trying to answer is whether increasing the > size > > of the pager cache will reduce the amount of I/O required by a single > > process in the case where a database is modified concurrently. > > The only way to determine how big the effect is in your specific > situation is to measure it yourself. > 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. Thanks! I had been over the file format -- clearly I need to read slower :) -Rowan _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
