Merge pull request #424 from tmo-github/TMO_ttrss

Modify query to avoid a full table scan on MySQL

diff --git a/include/functions2.php b/include/functions2.php
index 866c92ec90b0a3931d753c33ebbdc7b4a70be86e..29594076c1c6baaac8fc87560a41652863b269c8 100644 (file)
--- a/include/functions2.php
+++ b/include/functions2.php
@@ -1975,8 +1975,8 @@
        }
 
        function getLastArticleId() {
-               $result = db_query("SELECT MAX(ref_id) AS id FROM ttrss_user_entries
-                       WHERE owner_uid = " . $_SESSION["uid"]);
+               $result = db_query("SELECT ref_id AS id FROM ttrss_user_entries
+                       WHERE owner_uid = " . $_SESSION["uid"] . " ORDER BY ref_id DESC LIMIT 1");
 
                if (db_num_rows($result) == 1) {
                        return db_fetch_result($result, 0, "id");