From 332ff5cfb8e52bb9a9f12a0d535c0f0c5e30397a Mon Sep 17 00:00:00 2001
From: Andrew Dolgov <noreply@fakecake.org>
Date: Tue, 4 Aug 2015 20:38:43 +0300
Subject: [PATCH] add a very obvious speed improvement to topmost_id
 calculation

---
 include/functions2.php | 7 +++++++
 1 file changed, 7 insertions(+)

diff --git a/include/functions2.php b/include/functions2.php
index 9e4f0b0e..1898aa2e 100644
--- a/include/functions2.php
+++ b/include/functions2.php
@@ -716,6 +716,12 @@
 				if ($feed == -3)
 					$first_id_query_strategy_part = "true";
 
+				if (DB_TYPE == "pgsql") {
+					$sanity_interval_qpart = "date_entered >= NOW() - INTERVAL '1 hour' AND";
+				} else {
+					$sanity_interval_qpart = "date_entered >= DATE_SUB(NOW(), INTERVAL 1 hour) AND";
+				}
+
 				if (!$search) {
 					// if previous topmost article id changed that means our current pagination is no longer valid
 					$query = "SELECT DISTINCT
@@ -739,6 +745,7 @@
 						$search_query_part
 						$start_ts_query_part
 						$since_id_part
+						$sanity_interval_qpart
 						$first_id_query_strategy_part ORDER BY $order_by LIMIT 1";
 
 					if ($_REQUEST["debug"]) {
-- 
2.39.5