Overview
Artifact ID: | 95ef0509fc15cbecac7a82a9caec78c117b9f3fa |
---|---|
Ticket: | 55fa0d5468164b23a5ff122ff1da69f78e6b0ef2
System.Data.Sqlite - Entrypted Database query execution is 10 times slower versions starting from 1.0.100.0 |
User & Date: | anonymous 2019-09-12 07:05:35 |
Changes
- icomment:
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?
- login: "anonymous"
- mimetype: "text/x-fossil-plain"