[wp-trac] [WordPress Trac] #24498: Improving performance of meta_form()
WordPress Trac
noreply at wordpress.org
Thu Jul 23 05:09:15 UTC 2015
#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
More information about the wp-trac
mailing list