From 6080cca9ca1de60a5d4a1ef06d4873eca07d9ef2 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Fri, 24 Jan 2020 14:25:31 +0300 Subject: scrap counter cache system; rework counters to sum() booleans instead --- classes/rssutils.php | 20 +++----------------- 1 file changed, 3 insertions(+), 17 deletions(-) (limited to 'classes/rssutils.php') diff --git a/classes/rssutils.php b/classes/rssutils.php index 66008899b..831ac1baf 100755 --- a/classes/rssutils.php +++ b/classes/rssutils.php @@ -1469,26 +1469,12 @@ class RSSUtils { mb_strtolower(strip_tags($title), 'utf-8')); } + /* counter cache is no longer used, if called truncate leftover data */ static function cleanup_counters_cache() { $pdo = Db::pdo(); - $res = $pdo->query("DELETE FROM ttrss_counters_cache - WHERE feed_id > 0 AND - (SELECT COUNT(id) FROM ttrss_feeds WHERE - id = feed_id AND - ttrss_counters_cache.owner_uid = ttrss_feeds.owner_uid) = 0"); - - $frows = $res->rowCount(); - - $res = $pdo->query("DELETE FROM ttrss_cat_counters_cache - WHERE feed_id > 0 AND - (SELECT COUNT(id) FROM ttrss_feed_categories WHERE - id = feed_id AND - ttrss_cat_counters_cache.owner_uid = ttrss_feed_categories.owner_uid) = 0"); - - $crows = $res->rowCount(); - - Debug::log("Removed $frows (feeds) $crows (cats) orphaned counter cache entries."); + $pdo->query("DELETE FROM ttrss_counters_cache"); + $pdo->query("DELETE FROM ttrss_cat_counters_cache"); } static function housekeeping_user($owner_uid) { -- cgit v1.2.3-54-g00ecf