[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