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]
> <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.
