[wp-trac] [WordPress Trac] #11741: Over-optimization in meta_form()
WordPress Trac
wp-trac at lists.automattic.com
Wed Jan 6 13:05:05 UTC 2010
#11741: Over-optimization in meta_form()
-------------------------------+--------------------------------------------
Reporter: Denis-de-Bernardy | Owner:
Type: defect (bug) | Status: new
Priority: normal | Milestone: 3.0
Component: Optimization | Version: 2.9
Severity: normal | Keywords: has-patch
-------------------------------+--------------------------------------------
The meta_form() function is the only one in WP that does a query that uses
LOWER().
I believe we introduced an over-optimization in the changeset that added
the LOWER() statement. We could strip it, since we're using a
natcasesort() immediately after. This would additionally allow to use the
index on the meta_key column.
--
Ticket URL: <http://core.trac.wordpress.org/ticket/11741>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software
More information about the wp-trac
mailing list