Good to hear Mike. You may want to investigate doing a bulk update in pure SQL, and then invoking delta indexing on the model once (as opposed to many times on each relevant index):
ClientCategory.define_indexes ClientCategory.index_delta Not sure I'll make the next Rails Camp UK (unless it's really soon), but am hoping to swing through London for the August LRUG, should all go to plan. Perhaps I'll catch you there :) Cheers -- Pat On 19/06/2012, at 12:59 PM, mikej wrote: > Thanks very much Pat. I will work on this approach. The problem comes in > that clients frequently reorder categories, which means looping through all > the client_categories and updating them with other info. This was too slow > using delta indexing. I could do this as a background job or perhaps disable > thinking sphinx and reindex after all the changes have been made. I guess > updating in the background is safest. There are around 200 client_categories > per client. 25000 client_categories altogether at the minute. > > Sincere thanks, greetings from London town, hope to run into you at the next > railscamp. > > Mike > > -- > 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/-/HcP2jfXAqOAJ. > 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.
