Hi Daniel Any slowness in indexing is going to be related to the generated SQL query - when you say the query itself seems fast, how are you comparing it? I'd recommend running it through EXPLAIN to get some idea of what could be causing it to be slow.
Is there any way in which the join is different beyond the aliased name? As for upgrading - I'm not sure if there's been any changes related to query generation, but using the latest releases is always recommended (in this case, 2.1.0). Cheers -- Pat On 17/07/2013, at 3:09 AM, Daniel Vandersluis wrote: > 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. > > -- 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.
