diff options
author | Andrew Dolgov <[email protected]> | 2013-04-24 13:43:40 +0400 |
---|---|---|
committer | Andrew Dolgov <[email protected]> | 2013-04-24 13:43:40 +0400 |
commit | fce451a4f796e8ccafc9aec692cb8821c085fc97 (patch) | |
tree | a1fd20f3cfe662751770ed9dc2991bd6fc6c9348 | |
parent | 81c206634581595680ba784494f619ea977785f3 (diff) |
fix updating for pgsql
increase default batch size
remove random check between feedbrowser or update task executing
-rw-r--r-- | include/rssfuncs.php | 14 | ||||
-rwxr-xr-x | update.php | 21 |
2 files changed, 15 insertions, 20 deletions
diff --git a/include/rssfuncs.php b/include/rssfuncs.php index e9b9c7142..ac00a9408 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 c301083f9..ce354bbae 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"])) { |