Do you have an index on your delta column? If not, adding one might help significantly, without even adding the where clause.
- Josh On Mar 24, 5:12 am, "Damon P. Cortesi" <[email protected]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---
