[wp-trac] Re: [WordPress Trac] #8561: query in meta_form() function in /wp-admin/includes/template.php causes post/page editing to load slowly

[WordPress Trac]

#8561: query in meta_form() function in /wp-admin/includes/template.php causes
post/page editing to load slowly
-----------------------------------------+----------------------------------
 Reporter:  fastpipe                     |        Owner:  anonymous
     Type:  defect                       |       Status:  new      
 Priority:  high                         |    Milestone:  2.8      
Component:  Administration               |      Version:  2.7      
 Severity:  critical                     |   Resolution:           
 Keywords:  meta_key,postmeta,post,page  |  
-----------------------------------------+----------------------------------
Comment (by vladimir_kolesnikov):

 Actually there's no need in ORDER BY at all as natcasesort() is used to
 sort the retrieved array.

 I would suggest this query:

 {{{
 SELECT DISTINCT meta_key
 FROM wp_postmeta
 WHERE meta_key NOT LIKE '\_%'
 LIMIT {$limit}
 }}}

-- 
Ticket URL: <http://trac.wordpress.org/ticket/8561#comment:1>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software