From 7b3110c9c97346c7625fba81238d2119381e2247 Mon Sep 17 00:00:00 2001 From: Bram Schoenmakers Date: Thu, 19 Jun 2014 10:29:48 +0200 Subject: [PATCH] Fix for testing filters getting stuck sometimes. Sometimes when testing a filter the database becomes unresponsive, stuck in a long query. Solution: properly join ttrss_entries and ttrss_user_entries instead of working with their carthesian product. --- include/functions2.php | 6 ++++-- 1 file changed, 4 insertions(+), 2 deletions(-) diff --git a/include/functions2.php b/include/functions2.php index 5228d875..507c5343 100644 --- a/include/functions2.php +++ b/include/functions2.php @@ -426,8 +426,10 @@ // Try to check if SQL regexp implementation chokes on a valid regexp - $result = db_query("SELECT true AS true_val FROM ttrss_entries, - ttrss_user_entries, ttrss_feeds + $result = db_query("SELECT true AS true_val + FROM ttrss_entries + JOIN ttrss_user_entries ON ttrss_entries.id = ttrss_user_entries.ref_id + JOIN ttrss_feeds ON ttrss_feeds.id = ttrss_user_entries.feed_id WHERE $filter_query_part LIMIT 1", false); if ($result) { -- 2.39.2