On 11/08/2010, at 5:17 AM, gmoniey wrote: > 1. The delayed_job query is running every second. Is there a way to > reduce the frequency?
Delayed::Worker.sleep_delay = 60 That's from the docs of the collectiveidea fork of delayed_job, but I think it's what's used for the gems these days. It might exist in the original, too. > 2. It seems that the run_at <= now() prevents any indexes to have an > effect, as it results in a full table scan (the size of my table is > 174307) > > I'm wondering if its possible to clean up this query a little bit to > help take advantage of indexes, but I dont know where to look. Again, this is managed by Delayed Job, not TS/ts-delayed-delta. Off the top of my head, though, I can't think of any quick fixes to the query - you could add a boolean column 'run', set that to true on success, but that involves forking delayed job. Up to you, really :) -- Pat -- 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.
