> On Fri, Sep 12, 2014 at 5:00 AM, Paul <[email protected]> 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 > [email protected]
Thank you! _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
