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

[Simon Slavin]

On 27 Jul 2015, at 3:04pm, Igor Tandetnik <igor at tandetnik.org> wrote:

> That's a common technique with LEFT JOIN

Thanks, Igor.


On 27 Jul 2015, at 1:44pm, rotaiv <rotaiv at gmail.com> wrote:

> SELECT home.fpath
> FROM home
> LEFT JOIN work ON work.fpath = home.fpath
> WHERE work.fpath IS NULL
> AND home.ftype = 'f?;

Can you verify that you have an index on work.fpath ?  16 seconds is still a 
little slower than it should be.

Simon.