On Jun 17, 2009, at 12:56 PM, Dave Toll wrote:
> What is the correct way to specify that SQLite should perform no
> caching
> (or at least minimal caching)? PRAGMA cache_size=0 seems to have no
> effect - either it continues to use the default, or tries to caches
> everything.
Did you try "PRAGMA cache_size=10"?
You can use sqlite3_config() with SQLITE_CONFIG_PCACHE to install your
very own cache manager that does anything you like. See
http://www.sqlite.org/c3ref/config.html
http://www.sqlite.org/c3ref/c_config_getmalloc.html
http://www.sqlite.org/c3ref/pcache_methods.html
Other resources:
http://www.sqlite.org/malloc.html#pagecache
http://www.sqlite.org/c3ref/soft_heap_limit.html
D. Richard Hipp
[email protected]
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
