[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:  assigned
 Priority:  normal          |   Milestone:  4.3
Component:  Administration  |     Version:  3.5
 Severity:  normal          |  Resolution:
 Keywords:  has-patch       |     Focuses:  performance
----------------------------+--------------------------

Comment (by dd32):

 One main thing to keep in mind while testing this, is that (although you
 would think it wouldn't make that much of a difference) latin1 vs utf8 vs
 utf8mb4 seems to make a significant different here in performance, however
 the original being slow stands out under them all.

 [attachment:24498.patch 24498.patch] seems to be safe to me, so lets go
 for it for 4.3.

 If this still has performance issues for larger sites, I'd suggest that it
 should perhaps be cached in a transient (and cleared when an non-
 underscored field is set). This might be worth looking at in 4.4.

 > The other option is that it's written as meta_key {{{NOT BETWEEN '_' AND
 '`'}}} which should filter out all which start with _ I think - but i'm
 not sure what performance implications that would have (` is the next
 character up from _)
 Just to loop back to this, the performance isn't great, MySQL doens't
 optimize it the same :)

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