One other question about WAL mode and simultaneous readers and writers: How are people setting their page caches? My read is that shared cache is probably not what's wanted. I was setting my reader caches to be bigger than my writer cache under the assumption that writers write and then move on whereas readers would benefit from having more data cached, but I'm now thinking that the disk cache should be getting me the latter effect and increasing the size of the write cache should allow the writer to run longer without having to flush from memory to disk. Is there any standard advice in this regard or is this the sort of question where the answer is "experiment".
Mark _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
