Artifact
e95a0c30380976cb5de9709b3d76d2c2ff6d2a18:
Ticket change
[e95a0c3038]
- Ticket
[55fa0d5468] System.Data.Sqlite - Entrypted Database query execution is 10 times slower versions starting from 1.0.100.0 status still Open with 4 other changes
by
anonymous
2019-09-09 11:57:12.
D 2019-09-09T11:57:12.950
J icomment Also\swe\sfound\sout\sthat,\sthe\scritical\schange\sin\s1.0.100.00\s\swhich\sis\sthe\supdate\sof\s\sSqlite\score\slibrary\sto\sthe\s3.12.1.\sAs\sexplained\sin\sthe\sbelow\slink,\sthe\sdefault\spage\ssize\shas\sbeen\schanged\sto\s4096\sbytes\sand\sthe\sdefault\scache\ssize\sis\sset\sto\s-2000\s(which\sis\s2000\sKB).\s\r\n\r\nhttps://www.sqlite.org/pgszchng2016.html\s\r\n\r\nWhen\swe\sset\sthe\scache\ssize\sto\shigher\svalue\s(-100000)\sin\sthe\squery\sstring,\sthe\squeries\sran\swithout\sany\sslowdown.\sIs\sthis\sis\san\sexpected\sconcequense\sof\sthe\supdate\s3.12.1.
J login anonymous
J mimetype text/x-fossil-plain
J username Daison\sPaul
K 55fa0d5468164b23a5ff122ff1da69f78e6b0ef2
U anonymous
Z 2b37410e04b80543b58152669c6157fd
