On Fri, Sep 12, 2014 at 5:00 AM, Paul <de...@ukr.net> wrote: > > 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'? >
Set all cache sizes individually. > > (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? > Each database has its own cache. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users