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