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