[sqlite] setting cache_size to 0 right after opening a connection is ignored

2015-11-11 Thread Richard Hipp
On 11/11/15, Richard Hipp wrote: > On 11/10/15, Ousherovitch Alex wrote: >> >> setting PRAGMA cache_size to zero is a no-op and the default (2000 pages) >> will be used if it's done right after opening a database. > > I'm unable to reproduce this problem. Do you have a test case? > I see now.

[sqlite] setting cache_size to 0 right after opening a connection is ignored

2015-11-11 Thread Richard Hipp
On 11/10/15, Ousherovitch Alex wrote: > > setting PRAGMA cache_size to zero is a no-op and the default (2000 pages) > will be used if it's done right after opening a database. I'm unable to reproduce this problem. Do you have a test case? -- D. Richard Hipp drh at sqlite.org

[sqlite] setting cache_size to 0 right after opening a connection is ignored

2015-11-10 Thread Ousherovitch Alex
This issue seems to have been introduced in one of the recent releases - setting PRAGMA cache_size to zero is a no-op and the default (2000 pages) will be used if it's done right after opening a database. The reason seems to be that sPragmaNames entry for cache_size has mPragFlag value of zero,