Re: [sqlite] performance issue, v.3.10 compared to v.3.14 (inner joins)

unction), and temp.trtu table is a temp table, created with statement "CREATE TEMP TABLE temp.trtu (name TEXT, edition INTEGER, update_no INTEGER, pos INTEGER) " dixi On 11 August 2016 at 11:48, Richard Hipp wrote: > On 8/10/16, Raja Kajiev wrote: > > The issue is: one of request

[sqlite] performance issue, v.3.10 compared to v.3.14 (inner joins)

The issue is: one of requests performed in my app was executed in ~7 seconds in v.3.10, but in v.3.14 execution time is ~13-15 seconds. That's really itching in my case. The sql request in question includes "inner join" constructs. I also remember that in version prior to 3.10 the execution time fo