From 1cb072efb9fbd66266c9b934f676e40c60c6cc8b Mon Sep 17 00:00:00 2001 From: Erik Moeller Date: Fri, 23 May 2003 06:41:14 +0000 Subject: [PATCH] Make index use explicit so that InnoDB doesn't use the slower cur_namespace index. --- includes/SpecialAncientpages.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/includes/SpecialAncientpages.php b/includes/SpecialAncientpages.php index 33323aa919..c06f8c8bf5 100644 --- a/includes/SpecialAncientpages.php +++ b/includes/SpecialAncientpages.php @@ -13,7 +13,7 @@ function wfSpecialAncientpages() if ( ! $offset ) { $offset = 0; } $sql = "SELECT cur_title,cur_user,cur_user_text,cur_comment," . - "cur_timestamp FROM cur " . + "cur_timestamp FROM cur USE INDEX (namespace_redirect_timestamp) " . "WHERE cur_namespace=0 AND cur_is_redirect=0 " . " ORDER BY cur_timestamp LIMIT {$offset}, {$limit}"; $res = wfQuery( $sql, $fname ); -- 2.20.1