* Specify USE INDEX on Allpages chunk queries, sometimes gets lost

  due to bogus optimization

diff --git a/RELEASE-NOTES b/RELEASE-NOTES
index 5820eee..93cbf8e 100644 (file)
--- 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 a7dae9d..26e7434 100644 (file)
--- 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',
                )
        );