From e8792b4206ebbb5a0ec2787b22523332ba3b7ccb Mon Sep 17 00:00:00 2001
From: Domas Mituzas <midom@users.mediawiki.org>
Date: Sat, 12 Nov 2005 19:12:54 +0000
Subject: [PATCH] avoid filesorts on big dataset with name_title index, use
 timestamp scanning, warning, might have table scans on rarely-edited
 namespaces

---
 includes/SpecialRecentchanges.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/includes/SpecialRecentchanges.php b/includes/SpecialRecentchanges.php
index 812369417f..2f9e85fb79 100644
--- a/includes/SpecialRecentchanges.php
+++ b/includes/SpecialRecentchanges.php
@@ -138,7 +138,7 @@ function wfSpecialRecentchanges( $par, $specialPage ) {
 	$uid = $wgUser->getID();
 
 	// Perform query
-	$sql2 = "SELECT * FROM $recentchanges " .
+	$sql2 = "SELECT * FROM $recentchanges FORCE INDEX (rc_timestamp) " .
 	  ($uid ? "LEFT OUTER JOIN $watchlist ON wl_user={$uid} AND wl_title=rc_title AND wl_namespace=rc_namespace " : "") .
 	  "WHERE rc_timestamp > '{$cutoff}' {$hidem} " .
 	  "ORDER BY rc_timestamp DESC";
-- 
2.20.1