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