On Jun 16, 2009, at 8:28 PM, Dave Toll wrote: > Hello list > > > > I've noticed that if I call "PRAGMA cache_size=0", my database rows > are > still cached (very little disk access observed). If I call "PRAGMA > cache_size=1" I can see that there is very little caching (disk access > observed). Is there a minimum allowed cache_size setting? Does > cache_size=0 mean "cache everything"? I am using SQLite 3.6.13 with > the > default page cache, and shared-cache enabled.
I think any cache size suggestion less than 10 is ignored. That used to be the case. I don't know if it still is. Note that this does *not* control your operating systems file cache. This is SQLite's user-space cache only. If more pages than the cache allotment are required, the the cache size limit is automatically increased. D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
