Re: Django aggregation does excessive GROUP BY clauses

2011-11-02 Thread christian.oudard
Opened a bug: https://code.djangoproject.com/ticket/17144 I think I might take a crack at fixing this one. On Nov 1, 9:06 pm, Karen Tracey wrote: > On Tue, Nov 1, 2011 at 6:19 PM, christian.oudard > > > > > > > > > > wrote: > > I am doing a very simple aggregation using the Django ORM, and it

Re: Django aggregation does excessive GROUP BY clauses

2011-11-01 Thread Karen Tracey
On Tue, Nov 1, 2011 at 6:19 PM, christian.oudard wrote: > I am doing a very simple aggregation using the Django ORM, and it is > producing a GROUP BY clause that includes the data field, which is > very large, and is slowing down the query by over 100-fold. > > Here is a simplified version of the