Thank you for the speedy response and references. Is there a way to determine when the cache has been filled or how full it currently is? I set the pragma cache_size to 64 GiB per the online documentation.
________________________________________ From: [email protected] [[email protected]] on behalf of Simon Slavin [[email protected]] Sent: Tuesday, August 28, 2012 11:34 AM To: General Discussion of SQLite Database Subject: Re: [sqlite] How to determine the effective cache size On 28 Aug 2012, at 7:19pm, "Foster, Kristina (CIV)" <[email protected]> wrote: > Is there an SQLite command to determine the effective cache_size, or how much > of the cache is currently being used? I haven't seen any solutions for using > the Python sqlite module. I also haven't seen any solutions for determining > the cache size for SQLite for the interactive command line. Take a look at http://www.sqlite.org/pragma.html#pragma_cache_size You should assume that as soon as the cache has been filled the first time, it is all in use all the time until you close your connection. Obviously deleting data can expire lots of pages, but as soon as you start handling more data the cache will fill up again. For a detailed understanding of some aspects of cache management, read http://www.sqlite.org/c3ref/pcache_methods2.html however almost nobody needs to know this stuff. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
