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:56:27|
- Change icomment to:
We have attached the sample solution to replicate the issue. There are 2 databases, one is encrypted and the other one is unencrypted. The testTable contains 15k mocked rocords.
The console application uses the system.Sqlite.Data V1.0.100.00 to query both DB and displays the time to execute a select query. We observed a latency of 4-5 times in the encrypted db compared to the unencryped db.
- Change login to "anonymous"
- Change mimetype to "text/x-fossil-plain"
- Change username to "Daison Paul"