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.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to