[wp-trac] Re: [WordPress Trac] #2604: SQL Query Optimization

WordPress Trac wp-trac at lists.automattic.com
Mon Apr 17 03:00:35 GMT 2006


#2604: SQL Query Optimization
----------------------------+-----------------------------------------------
       Id:  2604            |      Status:  new                     
Component:  Administration  |    Modified:  Mon Apr 17 03:00:35 2006
 Severity:  normal          |   Milestone:  2.1                     
 Priority:  normal          |     Version:  2.0.2                   
    Owner:  ryan            |    Reporter:  ryan                    
----------------------------+-----------------------------------------------
Comment (by ryan):

 {{{
 these two queries:
                     66 Query     SELECT * FROM wp_categories WHERE cat_ID
 > 0 HAVING category_count > 0 ORDER BY cat_name asc
                     66 Query     SELECT * FROM wp_categories WHERE cat_ID
 > 0 HAVING link_count > 0 ORDER BY cat_name ASC
 could possibly be rewritten into link_count>0 or category_count>0
 }}}

 Anyone want to tackle this part?  Eliminate "HAVING".  Look in
 get_categories().

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


More information about the wp-trac mailing list