[wp-trac] Re: [WordPress Trac] #9007: Poor get_category_children() performance; rewrite to use get_term_children()

[WordPress Trac]

#9007: Poor get_category_children() performance; rewrite to use
get_term_children()
--------------------------+-------------------------------------------------
 Reporter:  _timk         |        Owner:  anonymous
     Type:  defect (bug)  |       Status:  new      
 Priority:  normal        |    Milestone:  2.8      
Component:  General       |      Version:  2.7      
 Severity:  normal        |   Resolution:           
 Keywords:                |  
--------------------------+-------------------------------------------------
Comment (by _timk):

 I re-ran the tests and came up with rough (time- and microtime-measured)
 execution times of 87 seconds and 0.00099 seconds for the original and
 revised implementations, respectively.

 Improvement of almost 5 orders of magnitude for my case, extracting just
 under 600 child categories from a total of 1500+ in the database.

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