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
