That is the machine. Originally. it was taking 40+ minutes. I upgraded to the latest version and it decreased to 16 seconds. With indexes, 5 seconds. :-D
On Tue, Jul 28, 2015 at 2:53 PM, Simon Slavin <slavins at bigfraud.org> wrote: > > 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. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users >
