I deal with a relevantly small database that fits into cache. The database is accesseed by single application and single thread for both read and write. I also use PRAGMA locking_mode=exclusive.
As far as I understand between transactions the cache is invalidated and all pages are removed. I would like to avoid this. There was a question on this topic several years ago. http://www.nabble.com/Cleared-pager-cache-td1037035.html#a1037035 By that time D. Richard Hipp answered that it was impossible. Thanks, Efim -- View this message in context: http://www.nabble.com/Is-there-any-way-to-avoid-cache-invalidation-between-transactions--tp22147444p22147444.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users