Re: [Fofredux-devel] Reduce cpu usage?

[Andrew T. <ajt...@hi...>]

On 1/31/07, Miles Beck <mil...@gm...> wrote:
> Here is the log of the cpu utlization. Is there a way to find out
> I did notice that when you click on the Edit link for a feed you can
> set an update interval. I tried setting a feed to a one minute update
> and it did not seem to work. Using this method (if it worked) I could
> set up half my feeds to be every 30 minutes, and the other half to be
> every 60 minutes. Though even this would not solve the problem as it
> is an excessive mysql query which seems to be the culprit.

Yeah, I don't know when the 'update interval' showed up, but I don't
believe it's being used currently. The 'slickest'/easiest solution
would be to included a PHP script (or just bash script) that would
handle spacing out updating your feeds.

It would be called by cron every 30 or 60 mins, then do a query to the
DB to get, say, the 5 oldest feeds that are due for updating (based on
update interval) and update just those, and the next time cron called
it, it would get 5 (or whatever) different ones.

Sounds like something Kevin could probably do in 10 mins ;)