Anyone have any ideas how to speed up GROUP BY on huge views in recent versions of SQLite?
http://www.sqlite.org/cvstrac/tktview?tn=1809 The older versions of SQLite (prior to SQLite 3.2.6) used to perform GROUP BY operations in the main table loop, grouping rows as it went along. But the new version appears to create a huge temp table of results, sort them, and only then determine the groups. This takes up a massive amount of temp store. The old GROUP BY algorithm excels in the case where there are a lot of groupable rows in the dataset; i.e., the typical case. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com