Re: [sqlite] Cache question

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

[sqlite] Cache question

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) -

Re: [sqlite] sqlite cache question

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 not really > sure how

Re: [sqlite] sqlite cache question

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 change the cache

[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 change the cache by pages size = 4096 and cache_size = 1 sqlite will then use appx. 40

[sqlite] SQLite cache question.

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, send email