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

Reply via email to