Hello, I have a SQLite database which has got 60 pages. For performance reasons, I am thinking of making SQLite cache all of this 60 pages, so for further queries no disk read will be performed. I believe when all pages are cached, SQLIte just has to read the cached pages and would be faster. To do this, when my library is initialized, I will execute a query like,
SELECT * FROM symbols; Symbols table contains all my data. I am not sure how SQLite does the page caching. So I am iterating over the results using sqlite3_step() and each iteration will read all of the columns. Is this enough for SQLite to build the cache? Or just executing the above query without iterating over rows would be sufficient? Are there any API functions that will tell how many pages are currently cached, cache misses etc..? Any help would be great -- -Navaneeth _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
