mysql> EXPLAIN SELECT dft.type, dft.title, dft.locked FROM date_format_type dft ORDER BY dft.title;
+----+-------------+-------+------+---------------+------+---------+------+------+----------------+
| id | select_type | table | type | possible_keys | key  | key_len | ref  | rows | Extra          |
+----+-------------+-------+------+---------------+------+---------+------+------+----------------+
|  1 | SIMPLE      | dft   | ALL  | NULL          | NULL | NULL    | NULL |    3 | Using filesort | 
+----+-------------+-------+------+---------------+------+---------+------+------+----------------+
1 row in set (0.03 sec)
CommentFileSizeAuthor
#1 667052_system_date_index.patch606 bytescatch

Comments

catch’s picture

Title: _system_date_format_types() causes a filesort » _system_date_format_types_build() causes a filesort
Status: Active » Needs review
StatusFileSize
new606 bytes

Patch. No upgrade path because this is a new table in D7.

dries’s picture

Status: Needs review » Fixed

I tested this, and I can confirm that we're using a filesort. The patch in #1 fixed that so I committed this to CVS HEAD. Thanks catch.

Status: Fixed » Closed (fixed)
Issue tags: -Performance

Automatically closed -- issue fixed for 2 weeks with no activity.