Never mind, I decided to update to 3.1.3 anyways. :) On Monday, February 9, 2015 at 1:16:03 PM UTC-5, Daniel Vandersluis wrote: > > 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]> >> 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]. >> 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]. 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.
