Am Fri, 14 Apr 2017 15:14:12 -0400 schrieb Richard Hipp: > On 4/14/17, Wolfgang Enzinger <sql...@enzinger.net> wrote: >> >> Thank you Richard. I have to admit that it took me quite a while and also >> reading the comment for check-in [1838a59c] several times to really >> understand your explanation. Duh, that's tricky indeed! >> > > But I've spent Good Friday working around it. Please try using the > tip of the left-join-view branch > (https://www.sqlite.org/src/timeline?c=left-join-view) and let me know > if that version works better for you. After some additional testing, > this optimization will likely be merge to trunk and appear in the next > release. Your beta-testing is important - Thanks.
Tested now with sqlite-snapshot-201705020130. Excellent! The query plan no longer shows any full table scan, and a specific query in my project runs ~ 1 ms. now - vs. 11-12 sec. using version 3.18. Great enhancement, thank you! _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users