Is there any reason an index would suddenly take 3x as long to index after adding an extra has_many attribute to the index definition? The query itself is completely indexed, and takes about 1.5ms to run (plus data collection time, there are about 200k records in the main table that is being indexed, plus a bunch of attributes - sphinx reports it as a 466MB index). Prior to adding the extra attribute, indexing took about 9 minutes, and now it takes 29. The new attribute averages just over 1 record per row, with a maximum of 78.
Possibly related is that adding the new attribute causes the query TS generates to add a duplicate join (with a different alias) to a join that's added by a different attribute (however as mentioned the query itself seems to be fast). I'm using ThinkingSphinx 2.0.11 currently - would updating to TS3 help? -- 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/groups/opt_out.
