[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:  (none)
     Type:  defect (bug)                         |      Status:  new
 Priority:  normal                               |   Milestone:  Future
                                                 |  Release
Component:  Administration                       |     Version:  4.3.1
 Severity:  critical                             |  Resolution:
 Keywords:  has-patch needs-testing needs-unit-  |     Focuses:
  tests                                          |  performance
-------------------------------------------------+-------------------------

Comment (by Uranbold):

 Replying to [comment:81 archon810]:
 > This is causing really bad perf issues for Yoast SEO and people with
 large wp_postmeta tables. For us with 11mln rows, the query is taking 40s
 on pretty beefy machine.
 >
 > https://github.com/Yoast/wordpress-seo/issues/12894

 How did you resolve the issue? We also have the same problem with YOAST
 and this query?

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