I've got a table with about 1.5m entries that I'm indexing using ThinkingSphinx (Twitter data, bios specifically - tweepsearch.com).
I have delta indexing enabled, which works fantastic. But as the size of the table has grown, as has the indexing time for the core index. As an example, I have a `rake ts:index` task running right now that's been going for 60 minutes. Not on indexing, though, on a db query - a "show processlist" in MySQL shows the following query: UPDATE `users` SET `delta` = 0 So I'm assuming this task is attempting to set the `delta` column of every row in my table, which is leading to this delay. It seems like this query is originating out of the reset_query method in: lib/thinking_sphinx/deltas/default_delta.rb I considered adding a WHERE clause to this to see if that might help, but wasn't quite sure this was the right place, or even if that would be appropriate. Any insight would be appreciated, dpc -- Damon P. Cortesi Security Guy, Twitter Apps www. tweetstats | tweepsearch | tweetsum .com --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
