Tilghman, Jack <jack.tilgh...@navteq.com> wrote:
> Thanks Igor, works great!
> 
> Btw, was there something incorrect about the way I had the query setup?

Not incorrect, just wasteful. I suspect the query was spending a lot of time 
working through rows where link and node do match up, only to throw them away 
in the end. In general, I found that the idiom

TableA left join TableB on (TableA.idInTableB = TableB.someId) where 
TableB.someId is null

almost always performs worse than the equivalent NOT EXISTS or NOT IN query.
-- 
Igor Tandetnik


_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to