Is there any reason in MySQL that every field and attribute has to be included in the group by clause (that is generated in the configuration file for the index)? As far as I understand, Postgres requires all fields in the select clause to be in the group by clause as well, but this is not the case in MySQL. Since it groups first by the primary key anyways, the extra columns are redundant, and I found that the a query for my index goes from 300-400ms to 1-2ms when I change the group by clause manually to only group by the primary key.
Thoughts? -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/thinking-sphinx. For more options, visit https://groups.google.com/d/optout.
