[wp-trac] [WordPress Trac] #39878: meta_form inner query is very slow for big post_meta tables

[WordPress Trac]

#39878: meta_form inner query is very slow for big post_meta tables
--------------------------------+------------------------------
 Reporter:  eddr                |       Owner:
     Type:  enhancement         |      Status:  new
 Priority:  normal              |   Milestone:  Awaiting Review
Component:  Options, Meta APIs  |     Version:  4.7.2
 Severity:  normal              |  Resolution:
 Keywords:                      |     Focuses:
--------------------------------+------------------------------

Comment (by eddr):

 Fixing and adding:

 1. Fix: My bad, the "order by" is not a performance issue
 2. Adding: my post_meta table has almost 200K rows. The query take around
 0.3-0.35s on average and is the slowest by far - new VPS with 1 core and
 2GB RAM on Linode, only one new site which is not public yet, so I
 consists 100% of the DB load.

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