Both "PRAGMA cache_size=10" and "PRAGMA cache_size=1" result in minimal caching, which is great. What is the expected behaviour of "PRAGMA cache_size=0" for the default page cache? I'd like to know whether setting cache_size=0 has some special significance, maybe it's a case I need to prevent.
Many thanks for the replies, Dave. -----Original Message----- From: D. Richard Hipp [mailto:[email protected]] Sent: 17 June 2009 10:08 To: General Discussion of SQLite Database Subject: Re: [sqlite] minimum cache_size for a database connection? 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
