System.Data.SQLite

Login

Artifact 3e07b51b4da2879f66089621d8727b3368082580:

Ticket change [3e07b51b4d] - New ticket [f9010bdcf9] Query execution takes longer time with System.Data.Sqlite1.0.113.0 and the same executes faster with 1.0.66.0 version dll. by anonymous 2020-06-16 05:27:22.
D 2020-06-16T05:27:22.762
J foundin 1.0.113.0
J icomment Query\sexecution\stakes\slonger\stime(10sec)\swith\sSystem.Data.Sqlite\s1.0.113.0\sand\sthe\ssame\sexecutes\sfaster(1sec)\swith\sSystem.Data.Sqlite\s1.0.66.0\sversion\sdll,\sbut\smy\scustomer\sis\swilling\sto\suse\sthe\slatest\sdll\sas\sthere\sis\sno\ssupport\sfor\sold\sversion.\r\n\r\nQuery:SELECT\s*\sFROM\s\sTable1\sINNER\sJOIN\sTable2\sON\sTable1.Id\s=\sTable2.Id\s\sWHERE\s1=1\s\sAND\s(Table2.value1=1\sAND\sTable2.value2=1)\sORDER\sBY\sDateTime\sDESC,\sNumber\sDESC\sLIMIT\s50\sOFFSET\s117050\s;\r\n\r\nKindly\sprovide\sthe\ssolution.
J login anonymous
J mimetype text/x-markdown
J private_contact daef53a5f3656e8a1ba4d16eddf685de5efbdea2
J severity Critical
J status Open
J title Query\sexecution\stakes\slonger\stime\swith\sSystem.Data.Sqlite1.0.113.0\sand\sthe\ssame\sexecutes\sfaster\swith\s1.0.66.0\sversion\sdll
J type Performance
K f9010bdcf91104d51da3ec7e6175da3bf5a16b4e
U anonymous
Z 6b196b63192cfd62fc9b0ee3cc88bdf2