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

Artifact ID: 3e07b51b4da2879f66089621d8727b3368082580 (Awaiting Moderator Approval)
Ticket: f9010bdcf91104d51da3ec7e6175da3bf5a16b4e
Query execution takes longer time with System.Data.Sqlite1.0.113.0 and the same executes faster with 1.0.66.0 version dll
User & Date: anonymous 2020-06-16 05:27:22
Changes

  1. foundin changed to: "1.0.113.0"
  2. icomment:
    Query execution takes longer time(10sec) with System.Data.Sqlite 1.0.113.0 and the same executes faster(1sec) with System.Data.Sqlite 1.0.66.0 version dll, but my customer is willing to use the latest dll as there is no support for old version.
    
    Query:SELECT * FROM  Table1 INNER JOIN Table2 ON Table1.Id = Table2.Id  WHERE 1=1  AND (Table2.value1=1 AND Table2.value2=1) ORDER BY DateTime DESC, Number DESC LIMIT 50 OFFSET 117050 ;
    
    Kindly provide the solution.
    
  3. login: "anonymous"
  4. mimetype: "text/x-markdown"
  5. private_contact changed to: "daef53a5f3656e8a1ba4d16eddf685de5efbdea2"
  6. severity changed to: "Critical"
  7. status changed to: "Open"
  8. title changed to:
    Query execution takes longer time with System.Data.Sqlite1.0.113.0 and the same executes faster with 1.0.66.0 version dll
    
  9. type changed to: "Performance"