From 7aa77ab15cf749a904a21cbcba1c414004380052 Mon Sep 17 00:00:00 2001 From: Aaron Schulz Date: Sun, 20 Apr 2008 23:46:03 +0000 Subject: [PATCH] Remove filesort from EXPLAIN --- includes/SpecialListusers.php | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) diff --git a/includes/SpecialListusers.php b/includes/SpecialListusers.php index da979d9453..9b456bc204 100644 --- a/includes/SpecialListusers.php +++ b/includes/SpecialListusers.php @@ -69,7 +69,8 @@ class UsersPager extends AlphabeticPager { list ($user,$user_groups,$ipblocks) = wfGetDB()->tableNamesN('user','user_groups','ipblocks'); $query = array( - 'tables' => " $user LEFT JOIN $user_groups ON user_id=ug_user LEFT JOIN $ipblocks ON user_id=ipb_user AND ipb_auto=0 ", + 'tables' => " $user FORCE INDEX(user_name) LEFT JOIN $user_groups ON user_id=ug_user + LEFT JOIN $ipblocks ON user_id=ipb_user AND ipb_auto=0 ", 'fields' => array('user_name', 'MAX(user_id) AS user_id', 'COUNT(ug_group) AS numgroups', -- 2.20.1