From 4a28f2bff572de12e15ed4fc0555a7088f2487df Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 20 Nov 2007 03:49:23 +0100 Subject: [PATCH] limit number of feeds selected by update daemon by last update --- update_daemon.php | 8 +++++++- 1 file changed, 7 insertions(+), 1 deletion(-) diff --git a/update_daemon.php b/update_daemon.php index 75229f66..e5d368a8 100644 --- a/update_daemon.php +++ b/update_daemon.php @@ -126,13 +126,19 @@ $login_thresh_qpart = ""; } + if (DB_TYPE == "pgsql") { + $update_limit_qpart = "AND ttrss_feeds.last_updated < NOW() - INTERVAL '".(DAEMON_SLEEP_INTERVAL*2)." seconds'"; + } else { + $update_limit_qpart = "AND ttrss_feeds.last_updated < DATE_SUB(NOW(), INTERVAL ".(DAEMON_SLEEP_INTERVAL*2)." SECOND)"; + } + $result = db_query($link, "SELECT feed_url,ttrss_feeds.id,owner_uid, SUBSTRING(last_updated,1,19) AS last_updated, update_interval FROM ttrss_feeds,ttrss_users WHERE - ttrss_users.id = owner_uid $login_thresh_qpart + ttrss_users.id = owner_uid $login_thresh_qpart $update_limit_qpart ORDER BY $random_qpart DESC LIMIT " . DAEMON_FEED_LIMIT); $user_prefs_cache = array(); -- 2.39.5