r56315 MediaWiki - Code Review archive

Repository:MediaWiki
Revision:r56314‎ | r56315 | r56316 >
Date:17:47, 14 September 2009
Author:aaron
Status:ok
Tags:
Comment:
force page index to be safe
Modified paths:
  • /trunk/extensions/FlaggedRevs/maintenance/updateStats.inc (modified) (history)

Diff [purge]

Index: trunk/extensions/FlaggedRevs/maintenance/updateStats.inc
@@ -167,7 +167,7 @@
168168 'GROUP BY' => 'rev_id', // stats are for each edit and ID is unique
169169 'ORDER BY' => 'rev_id ASC', // slight bias avoidance, if any
170170 'LIMIT' => $size, // sample size
171 - 'USE INDEX' => array('flaggedrevs' => 'PRIMARY','logging' => 'page_time')
 171+ 'USE INDEX' => array('page' => 'PRIMARY','flaggedrevs' => 'PRIMARY','logging' => 'page_time')
172172 ),
173173 array( // Assumes title unchanged (reasonable). Double-check NS though.
174174 'page' => array('INNER JOIN',array('page_id = rev_page','page_namespace' => $wgFlaggedRevsNamespaces)),

Follow-up revisions

RevisionCommit summaryAuthorDate
r57026merged r56315aaron21:15, 28 September 2009

Status & tagging log