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.
