I just wanted to make a correction: On 26 September 2011 22:50, Jaco Breitenbach <jjbreitenb...@gmail.com>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,821 pages. So, > dividing the used 3226.381 MB by the number of pages, gives 1024 bytes per > page. > > 2. The size reported by S*_PAGECACHE_SIZE reports only the size used to > store actual data, excluding the headers? I've checked again, and realised that SQLITE_STATUS_PAGECACHE_USED returns the number of pages and not a size in bytes as SQLITE_STATUS_PAGECACHE_OVERFLOW does, so the discrepancy is explained by me using the wrong constant to multiply with the page count to obtain physical memory size. Apologies for that. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
