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

[Simon Slavin]

On 28 Jul 2015, at 7:43pm, rotaiv <rotaiv at gmail.com> wrote:

> I create indexes and my original query time dropped from 16 seconds to this:
> 
> real  0m5.928s
> user  0m5.361s
> sys   0m0.565s

Is it worth checking on the machine you originally reported 40+ minutes for ?  
That one should be considerably faster.

Simon.