System.Data.SQLite
Ticket Change Details
Not logged in
Overview

Artifact ID: e95a0c30380976cb5de9709b3d76d2c2ff6d2a18
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-09 11:57:12
Changes

  1. 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).

    https://www.sqlite.org/pgszchng2016.html

    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.

  2. Change login to "anonymous"
  3. Change mimetype to "text/x-fossil-plain"
  4. Change username to "Daison Paul"