System.Data.Sqlite - Entrypted Database query execution is 10 times slower versions starting from 184.108.40.206
|User & Date:||anonymous 2019-09-12 07:05:35|
- Change icomment to:
We did not change the page size, instead we only set a higher values to the Cache size in the connection string as shown below:
@"data source=C:\data\testenc.sqlite;Read Only=False;FailIfMissing=True;cache_size=-100000"
And this fixed the issue. The queries run without any slowdown in the encrypted db.
However, we still dont have the actual reason why the issue occured in the encrypted database only. Also, will there be any sideeffets with the fix we made?
- Change login to "anonymous"
- Change mimetype to "text/x-fossil-plain"