Hi Roger Not sure exactly what you're referring to - can you provide the SQL statement and point out what you think could be more efficient?
Cheers -- Pat On 29/07/2012, at 5:06 PM, Roger Kind Kristiansen wrote: > Hi again, > > I just noticed that the SQL generated to my sphinx config returns a bit more > than I expected. I'll not dig to deep into my data model or concrete indices > first, as I assume this is yet another silly newbie mistake which is easy to > pinpoint. > > I've got one model which has a few associations (most are through a join > table, but not all). I've set up some indices and some attributes making use > of these associations. Now when I manually run the SQL generated by TS, I > notice the same values from the associated models are repeated multiple times > in each column. Is this expected behaviour, or is there some obvious thing > I'm missing which TS doesn't do for me automatically, like some explicit > grouping or unique constraints or something? > > This hasn't caused me any trouble up until now, but now I'm trying to sort by > counting the number of entries in one of the associated models and the > numbers get all screwy. As far as I can understand it's related to the > mentioned duplication. > > Cheers, > Roger > > -- > You received this message because you are subscribed to the Google Groups > "Thinking Sphinx" group. > To view this discussion on the web visit > https://groups.google.com/d/msg/thinking-sphinx/-/C_gW49zbm6kJ. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/thinking-sphinx?hl=en. -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
