http://translatewiki.net/sandwiki/profileinfo.php?sort=time_per_call&expand=SQL+Queries
Name Time (%) Memory (%) Count Calls/req ms/call kb/call ms/req kb/req
Special:Fewestrevisions 0.5% 0% 1 0 54813.9 3212.59 1.18 0.07
Version: 1.18.x
Severity: normal
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T28394 Missing Indexes, Inefficient queries and alike (tracking) | |||
| Open | None | T41661 Query pages improvements (tracking) | |||
| Declined | None | T29938 Special:Fewestrevisions has a very expensive query that filesorts and uses a temporary table |
mysql> describe SELECT page_namespace AS namespace,page_title AS title,COUNT(*) AS value,page_is_redirect AS redirect FROM mw_revision,mw_page WHERE page_namespace = '0' AND (page_id = rev_page) GROUP BY page_namespace, page_title, page_is_redirect HAVING COUNT(*) > 1 ORDER BY value LIMIT 50\G
+----+-------------+-------------+------+----------------------------+-------------+---------+------------------------+------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+-------------+------+----------------------------+-------------+---------+------------------------+------+----------------------------------------------+
| 1 | SIMPLE | mw_page | ref | PRIMARY,name_title | name_title | 4 | const | 3 | Using where; Using temporary; Using filesort |
| 1 | SIMPLE | mw_revision | ref | rev_page_id,page_timestamp | rev_page_id | 4 | wikidb.mw_page.page_id | 1 | Using index |
+----+-------------+-------------+------+----------------------------+-------------+---------+------------------------+------+----------------------------------------------+
2 rows in set (0.00 sec)
It's using temporary and filesorting...
(In reply to comment #2)
That's why it's marked as expensive :)
Sounds like WORKSFORME than ;-)
Please change summary, if you want that special page as "cheap".
(In reply to db from comment #3)
(In reply to comment #2)
That's why it's marked as expensive :)
Sounds like WORKSFORME than ;-)
Please change summary, if you want that special page as "cheap".
I'm going to mark this as WONTFIX. The special page is marked as "expensive", and I don't see any obvious way of making the query any cheaper