Am 24.12.2018 um 13:12 schrieb Richard Hipp:
There are now enhancements on a branch
(https://www.sqlite.org/src/timeline?r=reuse-subqueries) that should
fix your performance problem.
Since you seem to be someone who writes intense SQL, it would be
really cool if you could try out that branch and see if it solves or
causes any other problems.
Thank a lot. After compiling at check-in 06de44ec, the example query as
well as my full query are back to the execution time from 3.25.3 again.
While the variant proposed by Jake is faster and simpler for getting
just the paths (thanks for that), the full query includes additional
things like selecting properties of certain ancestors along the path.
Best,
Sebastian
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users