[wp-trac] [WordPress Trac] #6654: get_available_post_statuses() query is slow

WordPress Trac wp-trac at lists.automattic.com
Wed Apr 9 20:07:10 GMT 2008


#6654: get_available_post_statuses() query is slow
--------------------------+-------------------------------------------------
 Reporter:  ryan          |       Owner:  anonymous
     Type:  defect        |      Status:  new      
 Priority:  normal        |   Milestone:  2.5.1    
Component:  Optimization  |     Version:  2.5      
 Severity:  normal        |    Keywords:           
--------------------------+-------------------------------------------------
 The query in get_available_post_statuses() uses DISTINCT, which is slow.
 The query in wp_count_posts() is much faster and can be used to derive the
 same information.

-- 
Ticket URL: <http://trac.wordpress.org/ticket/6654>
WordPress Trac <http://trac.wordpress.org/>
WordPress blogging software


More information about the wp-trac mailing list