Author: meneldur
Description:
Just that: adding the possibility of sorting the files in a category by size. Would be useful on Wikimedia Commons, where some categories include both very huge and smaller pictures, the first ones being more useful for cropping and so on.
Version: unspecified
Severity: enhancement
I thought this might've been a dupe...
Either way, it's not a nice query
mysql> EXPLAIN SELECT img_name, img_size FROM categorylinks, page, image WHERE cl_from=page_id AND cl_to = 'Astronomy' AND page_title = img_name ORDER BY img_size;
+----+-------------+---------------+--------+---------------------------------+--------------+---------+-----------------------------------+------+-----------------------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+--------+---------------------------------+--------------+---------+-----------------------------------+------+-----------------------------------------------------------+
| 1 | SIMPLE | categorylinks | ref | cl_from,cl_timestamp,cl_sortkey | cl_timestamp | 257 | const | 227 | Using where; Using index; Using temporary; Using filesort |
| 1 | SIMPLE | page | eq_ref | PRIMARY | PRIMARY | 4 | commonswiki.categorylinks.cl_from | 1 | |
| 1 | SIMPLE | image | eq_ref | PRIMARY | PRIMARY | 257 | commonswiki.page.page_title | 1 | |
+----+-------------+---------------+--------+---------------------------------+--------------+---------+-----------------------------------+------+-----------------------------------------------------------+
3 rows in set (0.00 sec)
mysql> EXPLAIN SELECT img_name, img_size FROM categorylinks FORCE INDEX (cl_from), page, image WHERE cl_from=page_id AND cl_to = 'Astronomy' AND page_title = img_name ORDER BY img_size;
+----+-------------+---------------+--------+---------------+------------+---------+--------------------------------+----------+----------------------------------------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------+--------+---------------+------------+---------+--------------------------------+----------+----------------------------------------------+
| 1 | SIMPLE | page | index | PRIMARY | name_title | 261 | NULL | 19081712 | Using index; Using temporary; Using filesort |
| 1 | SIMPLE | image | eq_ref | PRIMARY | PRIMARY | 257 | commonswiki.page.page_title | 1 | |
| 1 | SIMPLE | categorylinks | eq_ref | cl_from | cl_from | 261 | commonswiki.page.page_id,const | 1 | Using where; Using index |
+----+-------------+---------------+--------+---------------+------------+---------+--------------------------------+----------+----------------------------------------------+
3 rows in set (0.00 sec)
Confirming bug as this is a valid feature request.
Reedy, I can't find a dupe bug. The only sorting feature requests close to this concern search results, like bug 16327 or bug 21139.
I'm also adding a 'design' keyword as we need also some UI input to know where the sort links should be added in the category page, in addition to a performance solution.
Could possibly be done with some sort of extension that adds file size to the beginning of the category sortkey (In combination with support for multiple sorting collations)