Re: [Fofredux-devel] Reduce cpu usage?

[Kevin <ke...@dr...>]

> 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.

Variable feed updates has been a feature for a while.

1) enable variable feed updates in settings page.
2) define an update interval for all your feeds, based on how fresh you
want the feed to be.  (default is 60min)
3) run update-quiet.php from cron periodically. (I do it every 30 mins)

What it does is only update a feed if the last time it was updated is
longer then $UPDATE_INTERVAL for that feed.  So every time
update-quiet.php is run, only a small number of feeds are updated.

For example: A feed like a web comic that only changes once a day, can
have an update interval set much higher (several hours) compared to a
chatty blog or news website.

The user can adjust the update intervals to their own liking.

--=20
Kevin