Thanks for that confirmation Daniel - just pushed a fix to the develop branch that’ll accept minimal_group_by (with or without ?) in config/thinking_sphinx.yml.
Cheers — Pat > On 7 Feb 2015, at 9:17 am, Daniel Vandersluis <[email protected]> > wrote: > > 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 >> <http://groups.google.com/group/thinking-sphinx>. >> For more options, visit https://groups.google.com/d/optout >> <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] > <mailto:[email protected]>. > To post to this group, send email to [email protected] > <mailto:[email protected]>. > Visit this group at http://groups.google.com/group/thinking-sphinx > <http://groups.google.com/group/thinking-sphinx>. > For more options, visit https://groups.google.com/d/optout > <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.
