From a950fbecb5c71fbed6adcf76fc1d4787f05ecb7f Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 15 Jul 2015 08:32:57 +0300 Subject: Revert "Performance breakthrough" This reverts commit c2916856541ed82b2f11b5f3ff29b1e4f5cd6b3e. --- include/functions.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/include/functions.php b/include/functions.php index a57c09478..22179e1a4 100644 --- a/include/functions.php +++ b/include/functions.php @@ -320,7 +320,8 @@ // purge orphaned posts in main content table $result = db_query("DELETE FROM ttrss_entries WHERE - id NOT IN (SELECT ref_id FROM ttrss_user_entries WHERE ref_id IS NOT NULL)"); + (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0"); + if ($do_output) { $rows = db_affected_rows($result); _debug("Purged $rows orphaned posts."); -- cgit v1.2.3