[wp-trac] [WordPress Trac] #33885: meta_form performs a potentially expensive query

[WordPress Trac]

#33885: meta_form performs a potentially expensive query
-------------------------------------+-----------------------------
 Reporter:  jorbin                   |       Owner:
     Type:  defect (bug)             |      Status:  new
 Priority:  normal                   |   Milestone:  Future Release
Component:  Administration           |     Version:  4.3.1
 Severity:  critical                 |  Resolution:
 Keywords:  has-patch needs-testing  |     Focuses:  performance
-------------------------------------+-----------------------------

Comment (by Val_):

 Just my 0.02$

 Found this slow query while testing WP 4.4.2
 Returns 0.5 million rows (of 1.9 million). Using where; Using temporary;
 Using filesort. 2.22 seconds

 After modifying meta_key field to varchar(191), everything seems to a lot
 better:
 Returns couple rows. Using where; Using index for group-by. Taking 0.0010
 seconds

 Waiting to final fix for this. Thank you.

--
Ticket URL: <https://core.trac.wordpress.org/ticket/33885#comment:25>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform