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

Artifact ID: d1990895253f63c0bbca47b0d3f052258ba64f85
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-29 10:15:25
Changes

  1. Change icomment to:

    What type of queries are slower, e.g. SELECT, INSERT, UPDATE, DELETE, etc? We observed only in SELECT Statements when the column is not indexed.

    Are you using the connection pool? We dont use the connection Pool. We just use the normal SQLiteConnection.

    How many threads are accessing the database?

    Ours is a multithreaded and mult-processes application. However, we were able to reproduce the issue with a single-threaded test application. So it occurs in all cases.

  2. Change login to "anonymous"
  3. Change mimetype to "text/x-fossil-plain"