https://bugzilla.wikimedia.org/show_bug.cgi?id=19640
Reedy <s...@reedyboy.net> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |s...@reedyboy.net
--- Comment #17 from Reedy <s...@reedyboy.net> 2011-01-07 02:21:23 UTC ---
mysql> DESCRIBE SELECT /* ApiQueryCategoryMembers::run */
cl_from,cl_sortkey,page_namespace,page_title,page_id FROM
`mw_page`,`mw_categorylinks` FORCE INDEX (cl_sortkey) WHERE (cl_from=page_id)
AND cl_to = 'Oh_rly' ORDER BY cl_sortkey, cl_from LIMIT 11\G
+----+-------------+------------------+--------+---------------+------------+---------+---------------------------------+------+------------------------------------------+
| id | select_type | table | type | possible_keys | key |
key_len | ref | rows | Extra
|
+----+-------------+------------------+--------+---------------+------------+---------+---------------------------------+------+------------------------------------------+
| 1 | SIMPLE | mw_categorylinks | ref | cl_sortkey | cl_sortkey |
257 | const | 2 | Using where; Using index;
Using filesort |
| 1 | SIMPLE | mw_page | eq_ref | PRIMARY | PRIMARY | 4
| wikidb.mw_categorylinks.cl_from | 1 |
|
+----+-------------+------------------+--------+---------------+------------+---------+---------------------------------+------+------------------------------------------+
2 rows in set (0.00 sec)
mysql>
Was wondering.
Just removing the order by removes the filesort ;)
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
