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.
