Hi all, In my battles with lots of connections competing over precious cache memory, I've considered giving some non-critical connections zero cache using `PRAGMA cache_size=0`.
Is this a reasonable thing to do? If zero is too extreme, what might a more moderate small cache size be? 32? 64? 100? Some of these connections are only opened to do `PRAGMA quick_check;`, I'm guessing that operation is not very cache-intensive, assuming it reads pages sequentially and checks them? Thanks for any advice on this, - Kim _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users