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

Artifact ID: da8c3fc7535160964080c708a0b6fe52186e29f6
Ticket: 55fa0d5468164b23a5ff122ff1da69f78e6b0ef2
System.Data.Sqlite - Entrypted Database query execution is 10 times slower versions starting from 1.0.100.0
User & Date: anonymous 2019-08-28 14:33:55
Changes

  1. Change foundin to "1.0.100.0"
  2. Change icomment to:

    Dear Team,

    We uses an encrypted Sqlite db for locally storing data in our WPF .Net application. We updated the System.Data.SQLite library to the latest version 1.0.111.0 from previous 1.0.94.0 and it was observed to be the queries taking enormous amount of time (10 times compared to 1.0.94.0) to respond.

    Upon detailed analysis it was found out that until 1.0.99.0 the issue is nonexistent and with 1.0.100.0 or higher versions it is occurring. It happens only with the encrypted database while querying non-index columns.

  3. Change login to "anonymous"
  4. Change mimetype to "text/x-fossil-plain"
  5. Change private_contact to "032b9071e63e6695d85e5edc0115028932eabe2b"
  6. Change severity to "Critical"
  7. Change status to "Open"
  8. Change title to:

    System.Data.Sqlite - Entrypted Database query execution is 10 times slower versions starting from 1.0.100.0

  9. Change type to "Incident"