System.Data.SQLite

Login
This project makes use of Eagle, provided by Mistachkin Systems.
Eagle: Secure Software Automation
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. foundin changed to: "1.0.100.0"
  2. icomment:
    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. login: "anonymous"
  4. mimetype: "text/x-fossil-plain"
  5. private_contact changed to: "032b9071e63e6695d85e5edc0115028932eabe2b"
  6. severity changed to: "Critical"
  7. status changed to: "Open"
  8. title changed to:
    System.Data.Sqlite - Entrypted Database query execution is 10 times slower  versions starting from  1.0.100.0
    
  9. type changed to: "Incident"