System.Data.SQLite

Login
Overview

Artifact ID: 3e07b51b4da2879f66089621d8727b3368082580
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"