r1352 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r1351‎ | r1352 | r1353 >
Date:06:41, 23 May 2003
Author:eloquence
Status:old
Tags:
Comment:
Make index use explicit so that InnoDB doesn't use the slower cur_namespace
index.
Modified paths:
  • /trunk/phase3/includes/SpecialAncientpages.php (modified) (history)

Diff [purge]

Index: trunk/phase3/includes/SpecialAncientpages.php
@@ -13,7 +13,7 @@
1414 if ( ! $offset ) { $offset = 0; }
1515
1616 $sql = "SELECT cur_title,cur_user,cur_user_text,cur_comment," .
17 - "cur_timestamp FROM cur " .
 17+ "cur_timestamp FROM cur USE INDEX (namespace_redirect_timestamp) " .
1818 "WHERE cur_namespace=0 AND cur_is_redirect=0 " .
1919 " ORDER BY cur_timestamp LIMIT {$offset}, {$limit}";
2020 $res = wfQuery( $sql, $fname );

Status & tagging log