> I do not set anything for the "application defined page cache", so > what is the behavior of the default one?
Default implementation of page cache uses all the size you said it to use and in some cases even more. So don't worry about that. Just remember that cache_size is not a global setting, it's a connection setting or (in case if you use shared cache) a setting for all connections to the same database file. So do your math and don't run accidentally out of memory. Pavel On Fri, Nov 19, 2010 at 4:21 PM, Yang <teddyyyy...@gmail.com> wrote: > I read from the docs that by setting > "PRAGMA cache_size = Number-of-pages;" > (http://www.sqlite.org/pragma.html#pragma_cache_size) > I can use a larger cache, but the same paragraph mentions that how > much is used is actually "at the discretion of the application defined > page cache" > > I do not set anything for the "application defined page cache", so > what is the behavior of the default one? > the application page cache page does not describe this. > with the default "application defined page cache", would it utilize > all of the cache I declared ? > > I am hoping to use a very large cache, for example 1G > > Thanks > Yang > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
