From 9e993b6bd884e158c399d3b87383937abaaf8afc Mon Sep 17 00:00:00 2001 From: Brion Vibber Date: Thu, 21 Jul 2005 12:53:29 +0000 Subject: [PATCH] * Specify USE INDEX on Allpages chunk queries, sometimes gets lost due to bogus optimization --- RELEASE-NOTES | 3 ++- includes/SpecialAllpages.php | 5 +++-- 2 files changed, 5 insertions(+), 3 deletions(-) diff --git a/RELEASE-NOTES b/RELEASE-NOTES index 5820eee6ea..93cbf8e5c3 100644 --- a/RELEASE-NOTES +++ b/RELEASE-NOTES @@ -584,7 +584,8 @@ of MediaWiki:Newpagetext) to &action=edit, if page is new. inverse checkbox, use friendlier relative offsets in index build * Bring back "Chick" skin for mobile devices. It needs testing. * Fix spelling of $wgForwardSearchUrl in DefaultSettings.php - +* Specify USE INDEX on Allpages chunk queries, sometimes gets lost + due to bogus optimization === Caveats === diff --git a/includes/SpecialAllpages.php b/includes/SpecialAllpages.php index a7dae9db22..26e7434aba 100644 --- a/includes/SpecialAllpages.php +++ b/includes/SpecialAllpages.php @@ -228,8 +228,9 @@ function indexShowChunk( $namespace = NS_MAIN, $from, $including = false ) { ), $fname, array( - 'ORDER BY' => 'page_title', - 'LIMIT' => $indexMaxperpage + 1 + 'ORDER BY' => 'page_title', + 'LIMIT' => $indexMaxperpage + 1, + 'USE INDEX' => 'name_title', ) ); -- 2.20.1