[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

[Igor Tandetnik]

On 7/27/2015 9:58 AM, Simon Slavin wrote:
> So you're checking both to see that [work.fpath = home.fpath ] and to see 
> that [work.fpath IS NULL].  This looks weird to me.

That's a common technique with LEFT JOIN - it's selecting home records 
that lack a corresponding work record. In other words, it's equivalent to

SELECT fpath
FROM home
WHERE fpath NOT IN (SELECT fpath FROM work)
AND home.ftype = 'f?;

-- 
Igor Tandetnik