From: Andrew Dolgov <fox@madoka.volgo-balt.ru>
Date: Wed, 24 Apr 2013 09:43:40 +0000 (+0400)
Subject: fix updating for pgsql
X-Git-Tag: 1.7.9~25^2~102
X-Git-Url: https://git.wh0rd.org/?p=tt-rss.git;a=commitdiff_plain;h=fce451a4f796e8ccafc9aec692cb8821c085fc97

fix updating for pgsql
increase default batch size
remove random check between feedbrowser or update task executing
---

diff --git a/include/rssfuncs.php b/include/rssfuncs.php
index e9b9c714..ac00a940 100644
--- a/include/rssfuncs.php
+++ b/include/rssfuncs.php
@@ -1,7 +1,7 @@
 <?php
-	define('DAEMON_UPDATE_LOGIN_LIMIT', 30);
-	define('DAEMON_FEED_LIMIT', 100);
-	define('DAEMON_SLEEP_INTERVAL', 60);
+	define_default('DAEMON_UPDATE_LOGIN_LIMIT', 30);
+	define_default('DAEMON_FEED_LIMIT', 500);
+	define_default('DAEMON_SLEEP_INTERVAL', 60);
 
 	function update_feedbrowser_cache() {
 
@@ -113,8 +113,7 @@
 		$query_limit = "";
 		if($limit) $query_limit = sprintf("LIMIT %d", $limit);
 
-		// We search for feed needing update.
-		$result = db_query("SELECT DISTINCT ttrss_feeds.feed_url
+		$query = "SELECT DISTINCT ttrss_feeds.feed_url, ttrss_feeds.last_updated
 			FROM
 				ttrss_feeds, ttrss_users, ttrss_user_prefs
 			WHERE
@@ -123,7 +122,10 @@
 				AND ttrss_user_prefs.pref_name = 'DEFAULT_UPDATE_INTERVAL'
 				$login_thresh_qpart $update_limit_qpart
 				$updstart_thresh_qpart
-			ORDER BY last_updated $query_limit");
+				ORDER BY last_updated $query_limit";
+
+		// We search for feed needing update.
+		$result = db_query($query);
 
 		if($debug) _debug(sprintf("Scheduled %d feeds to update...", db_num_rows($result)));
 
diff --git a/update.php b/update.php
index c301083f..ce354bba 100755
--- a/update.php
+++ b/update.php
@@ -184,24 +184,17 @@
 			_debug("warning: unable to create stampfile\n");
 		}
 
-		// Call to the feed batch update function
-		// or regenerate feedbrowser cache
-
-		if (rand(0,100) > 30) {
-			update_daemon_common();
-		} else {
-			$count = update_feedbrowser_cache();
-			_debug("Feedbrowser updated, $count feeds processed.");
-
-			purge_orphans( true);
+		update_daemon_common();
 
-			$rc = cleanup_tags( 14, 50000);
+		$count = update_feedbrowser_cache();
+		_debug("Feedbrowser updated, $count feeds processed.");
 
-			_debug("Cleaned $rc cached tags.");
+		purge_orphans( true);
 
-			PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op);
-		}
+		$rc = cleanup_tags( 14, 50000);
 
+		_debug("Cleaned $rc cached tags.");
+		PluginHost::getInstance()->run_hooks(PluginHost::HOOK_UPDATE_TASK, "hook_update_task", $op);
 	}
 
 	if (isset($options["cleanup-tags"])) {