Or solve two problems by improving the algorithm for non-indexed GROUP BY queries:
http://www.sqlite.org/cvstrac/tktview?tn=1809 D. Richard Hipp wrote: >Version 3.5.3 made a change to the way DISTINCT is processed. >Probably that change is making your particular case much slower. The >change can be seen at: > > http://www.sqlite.org/cvstrac/chngview?cn=4538 > >This change was in response to grumbling on the mailing list > > http://www.mail-archive.com/sqlite-users@sqlite.org/msg28894.html > >It would appear that I need to spend some time improving this >optimization - enabling it only in cases where it seems likely to >improve performance and disabling it in cases like yours were it makes >things much worse. We'll try to have a look at that for version 3.6.9. -- View this message in context: http://www.nabble.com/Re%3A-Big-performance-regressions-since-3.4.0--tp21302304p21345408.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users