Merge branch 'master' of tsia/tt-rss into master

[tt-rss.git] / classes / article.php

diff --git a/classes/article.php b/classes/article.php
index f1271284e84f6a2a23b58f25c627dbe656bcf8b6..edf95b74318659d11f96355df9249ed47b99325b 100644 (file)
--- a/classes/article.php
+++ b/classes/article.php
@@ -903,9 +903,14 @@ class Article extends Handler_Protected {
 
                // purge orphaned posts in main content table
 
+               if (DB_TYPE == "mysql")
+                       $limit_qpart = "LIMIT 5000";
+               else
+                       $limit_qpart = "";
+
                $pdo = Db::pdo();
                $res = $pdo->query("DELETE FROM ttrss_entries WHERE
-                       NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id)");
+                       NOT EXISTS (SELECT ref_id FROM ttrss_user_entries WHERE ref_id = id) $limit_qpart");
 
                if ($do_output) {
                        $rows = $res->rowCount();