Re: [sqlite] Cache question

2011-09-26 Thread Jaco Breitenbach
I just wanted to make a correction: On 26 September 2011 22:50, Jaco Breitenbach wrote: > Now as the cache usage increases, I find that it finally caps at 3226.381 > MB (of the total 4096 MB) before the overflow size starts to increase. At > an initial page size of 1300, the 4096 MB gives 3,303,

[sqlite] Cache question

2011-09-26 Thread Jaco Breitenbach
Dear experts, I have a question about the following cache related functions: - sqlite3_config(SQLITE_CONFIG_PAGECACHE, B, S, P) - sqlite3_status(SQLITE_STATUS_PAGECACHE_USED, C, H, 0) - sqlite3_status(SQLITE_STATUS_PAGECACHE_OVERFLOW, C, H, 0) - sqlite3_status(SQLITE_STATUS_PAGECACHE_

Re: [sqlite] sqlite cache question

2009-02-23 Thread Marcus Grimm
:mgr...@medcom-online.de] > Sent: 23 February 2009 06:07 > To: General Discussion of SQLite Database > Subject: [sqlite] sqlite cache question > > Hi all, > > I tried to scan the list and doc pages to understand better > the sqlite's concept of caching but I'm still

Re: [sqlite] sqlite cache question

2009-02-23 Thread Dave Toll
07 To: General Discussion of SQLite Database Subject: [sqlite] sqlite cache question Hi all, I tried to scan the list and doc pages to understand better the sqlite's concept of caching but I'm still not really sure how to change the cache parameters to get the best performance: Assuming I c

[sqlite] sqlite cache question

2009-02-23 Thread Marcus Grimm
Hi all, I tried to scan the list and doc pages to understand better the sqlite's concept of caching but I'm still not really sure how to change the cache parameters to get the best performance: Assuming I change the cache by pages size = 4096 and cache_size = 1 sqlite will then use appx. 40 M

[sqlite] SQLite cache question.

2007-06-19 Thread pompomJuice
at exactly is happening here? Regards. -- View this message in context: http://www.nabble.com/SQLite-cache-question.-tf3944886.html#a11190296 Sent from the SQLite mailing list archive at Nabble.com. - To unsubscribe, sen