From 894ebcf5e94c917f5e10e5196f74b8055e2b2407 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Tue, 21 Mar 2006 08:09:18 +0100 Subject: update_daemon work, remove unneeded indexes, query optimizations --- update_daemon.php | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) (limited to 'update_daemon.php') diff --git a/update_daemon.php b/update_daemon.php index cf51bdd3a..8c36fda68 100644 --- a/update_daemon.php +++ b/update_daemon.php @@ -55,8 +55,8 @@ while (true) { if (time() - $last_purge > PURGE_INTERVAL) { - print "Purging old posts...\n"; - global_purge_old_posts($link, true); + print "Purging old posts (random 30 feeds)...\n"; + global_purge_old_posts($link, true, 30); $last_purge = time(); } @@ -71,9 +71,11 @@ // Process all other feeds using last_updated and interval parameters + $random_qpart = sql_random_function(); + $result = db_query($link, "SELECT feed_url,id,owner_uid, SUBSTRING(last_updated,1,19) AS last_updated, - update_interval FROM ttrss_feeds ORDER BY last_updated DESC"); + update_interval FROM ttrss_feeds ORDER BY $random_qpart DESC"); $user_prefs_cache = array(); -- cgit v1.2.3-54-g00ecf