[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:  reopened
 Priority:  normal          |   Milestone:  4.3
Component:  Administration  |     Version:  3.5
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:  performance
----------------------------+--------------------------
Changes (by chriscct7):

 * status:  closed => reopened
 * resolution:  fixed =>


Comment:

 There's a couple other low hanging optimizations it looks like we can do
 here.

 First, I think we can get rid of the orderby, since we already run the
 result through natcasesort.

 Also, we can limit the meta it searches through by limiting to the post_id
 in the where clause.

 Attaching something I just wrote on a phone (so if you want to test it
 make sure to sanity check it for autocorrect gremlins before trying to
 apply it)

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