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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to