[sqlite] In-Memory DB cache_size

2016-03-17 Thread Michele Pradella
I check the default cache_size of a In-Memory DB and it's 2000 Do you think for that kind of DB I can put cache_size to 0 like default for TEMP DB? or you think it's better leave 2000? Just wandering if it's correct to have ram cache of a In-Memory DB

[sqlite] In-Memory DB cache_size

2016-03-17 Thread Jay Kreibich
An in-memory DB is held 100% in the cache (there is no backing store), so I believe it ignores this number and is allowed to grow up to the maximum DB size. The cache does not hold duplicate copies of pages held else-where in memory. -j On Mar 17, 2016, at 8:17 AM, Michele Pradella wrote