Thanks as always Pat! If I'm still on 3.0.6 will that fix ever be backported? Or will I need to update to 3.1.x when the change is pushed from develop to master?
On Saturday, February 7, 2015 at 11:50:50 PM UTC-5, Pat Allan wrote: > > 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] > <javascript:>> 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]> >> 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]. >> 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. >> >> >> > -- > 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.
