On 12/22/18, Sebastian Bank <sebastian.b...@uni-leipzig.de> wrote: > > With SQLite up to version 3.25.3 the query below (with the 500 example > items inserted below) takes about 0.2 seconds on my system. With version > 3.26.0 it takes over 6 seconds (with the full data set of around 24000 > items, it seems to become infeasible).
Thank you for the report. Bisecting shows that the slowdown is a result of the fix for ticket https://sqlite.org/src/info/787fa716be3a7f650cac in check-in https://sqlite.org/src/info/531eca6104e41e43 I'll see if we can find a way to get your query to run fast again without breaking the fix. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users