> 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
Thank you! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
