Perfect, using set_property works! Adding minimal_group_by (or minimal_group_by?) to the configuration file doesn't seem to work, though.
On Sunday, February 1, 2015 at 7:33:07 AM UTC-5, Pat Allan wrote: > > As of TS v3.0.6 there’s a way around this - the minimal_group_by? option, > which can be set on a per-index basis: > > set_property :minimal_group_by? => true > > Or try it in config/thinking_sphinx.yml for each environment (although a > quick glance at the code, maybe this won’t work? Would love confirmation - > I’m a little flat out at the moment as an organiser of RubyConf AU which > happens this week. If it doesn’t work via config/thinking_sphinx.yml, a > patch is certainly welcome!) > > On 31 Jan 2015, at 7:33 am, Daniel Vandersluis <[email protected] > <javascript:>> wrote: > > 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] <javascript:>. > To post to this group, send email to [email protected] > <javascript:>. > Visit this group at http://groups.google.com/group/thinking-sphinx. > For more options, visit https://groups.google.com/d/optout. > > > -- 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.
