| Index: branches/REL1_18/extensions/FlaggedRevs/dataclasses/FlaggedRevsStats.php |
| — | — | @@ -309,8 +309,9 @@ |
| 310 | 310 | array( 'rev_user' => 0, $timeCondition, "(rev_id % $mod) = 0" ), |
| 311 | 311 | __METHOD__, |
| 312 | 312 | array( |
| 313 | | - 'GROUP BY' => 'rev_id', |
| 314 | | - 'USE INDEX' => array( 'p' => 'PRIMARY', 'n' => 'PRIMARY' ) |
| | 313 | + 'GROUP BY' => array( 'rev_timestamp', 'rev_id' ), // user_timestamp INDEX used |
| | 314 | + 'USE INDEX' => array( 'revision' => 'user_timestamp' ), // sanity; mysql picks this |
| | 315 | + 'STRAIGHT_JOIN' |
| 315 | 316 | ), |
| 316 | 317 | array( |
| 317 | 318 | 'p' => array( 'INNER JOIN', array( // last review |