[wp-trac] [WordPress Trac] #24498: Improving performance of meta_form()

[WordPress Trac]

#24498: Improving performance of meta_form()
----------------------------+--------------------------
 Reporter:  lumaraf         |       Owner:  pento
     Type:  enhancement     |      Status:  closed
 Priority:  normal          |   Milestone:  4.3
Component:  Administration  |     Version:  3.5
 Severity:  normal          |  Resolution:  fixed
 Keywords:  has-patch       |     Focuses:  performance
----------------------------+--------------------------

Comment (by jeichorn):

 I have a site with 4.5 million wp_postmeta rows and this query is still
 slow (20 seconds).

 It looks like the where clause is used but in my case that still means
 creating a 4.1 million row temp table because of the distinct.  I can
 write a patch with a transient if that's the solution that will be
 accepted, but at least in my case the 20 second delay every time its empty
 for a feature that isn't useful isn't great (even if they used the
 meta_key drop down, showing 30 of the 2k keys isn't helpful).

 Should I start a new ticket or reopen this one?

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