From 7680d44ef21d3a8eec3e564516b348e0feb87e28 Mon Sep 17 00:00:00 2001 From: Andrew Dolgov Date: Wed, 15 Jul 2015 13:29:03 +0300 Subject: purge_orphans: optimize the query, maybe https://tt-rss.org/forum/viewtopic.php?f=1&t=3417&p=20408#p20407 --- include/functions.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/include/functions.php b/include/functions.php index 22179e1a4..e5f2ca486 100644 --- a/include/functions.php +++ b/include/functions.php @@ -320,7 +320,7 @@ // purge orphaned posts in main content table $result = db_query("DELETE FROM ttrss_entries WHERE - (SELECT COUNT(int_id) FROM ttrss_user_entries WHERE ref_id = id) = 0"); + NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id)"); if ($do_output) { $rows = db_affected_rows($result); -- cgit v1.2.3