System.Data.Sqlite - Entrypted Database query execution is 10 times slower versions starting from 22.214.171.124
|User & Date:||anonymous 2019-09-09 11:57:12|
- Change icomment to:
Also we found out that, the critical change in 1.0.100.00 which is the update of Sqlite core library to the 3.12.1. As explained in the below link, the default page size has been changed to 4096 bytes and the default cache size is set to -2000 (which is 2000 KB).
When we set the cache size to higher value (-100000) in the query string, the queries ran without any slowdown. Is this is an expected concequense of the update 3.12.1.
- Change login to "anonymous"
- Change mimetype to "text/x-fossil-plain"
- Change username to "Daison Paul"