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

Reply via email to