I have a few questions regarding 'cache_size' PRAGMA:
(Q1) Does this PRAGMA affects all attached databases or should I set it for
each
attached database individually like 'PRAGMA attached.cache_size = 100'?
(Q2) If it affects all databasess and, for example, I set it to 100, will it
mean every
database (attached or main) have its own separate cache of size 100 *
page_size
or is it single, shared cache?
Thank you,
Paul
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
