[sqlite] About Sqlite cache metch times and read() call times

2009-01-20 Thread yoky
Hi all, I add some debug information in sqlite3.c, and test Sqlite cache metch times, unmetch times and read() called times in Linux, I found that page unmetch times in cache is bigger than read() called times. Then I found in Btree.c getAndInitPage() function called sqlite3PageLookup,

[sqlite] About Sqlite cache

2008-12-22 Thread yoky
Hi all, I have some question about Sqlite cache: 1. In the Sqlite docs, It's said :" If you are doing UPDATEsor DELETEs that change many rows of a database and you do not mind if SQLite uses more memor