Dear All, We are observing that temp views are using page cache even after setting the cache_size= 0. I am stuck debugging this issue for the last two days. Any pointers will be greatly appreciated.
When we run a SQL query multiple times on a temp view our custom vfs is getting read call only for offset=24 and length=16. I believe its checking if the file is updated or not. *Details:* 1. Temp view is created by joining two tables. One of the table is in an attached database. 2. pragma cache_size= 0 is set immediately after opening the connection. 3. The cache_size zero is confirmed based on vfs calls for the table in the main database. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
