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

Artifact ID: a7abd4a4901feb7809cf4c37fdb62694966c2985
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:56:27
Changes

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

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