He said using the NGQP snapshot the query indeed runs fast. I think you mentally inserted some negation in that statement, DRH.
On Fri, Jun 28, 2013 at 8:47 AM, Richard Hipp <d...@sqlite.org> wrote: > On Thu, Jun 27, 2013 at 6:50 PM, Elan Feingold <e...@plexapp.com> wrote: > > > >> Q2 runs excruciatingly slowly in 3.7.15.2 (1m 28sec). We then observed > > >> that Q2 was fast in 3.7.14 (300ms), but slow in 3.7.15.2 and later > > (tested > > >> up until 3.7.17). > > >> > > > > > > Have you tried it with the NGQP snapshot? > > > > > > The NGQP was announced on this mailing list yesterday, but I see that > the > > > OP only subscribed as of today. Please see the original posting at > > > http://www.mail-archive.com/sqlite-users%40sqlite.org/msg77855.html > > > > > > I tried with the NGQP snapshot and the query indeed runs fast. Didn’t > > compare to <= 3.7.14, but it was fast. > > > > I get times like this: > > 3.7.14: 0.120s > 3.7.17: 14.998s > 3.8.0: 0.064s > > So on my runs, at least, it appears that 3.8.0 is about 2x faster than > 3.7.14. But you say that 3.8.0 is slower for you? What are your query > times? > > > -- > D. Richard Hipp > d...@sqlite.org > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
