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
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