[wp-trac] Re: [WordPress Trac] #3985: _get_cat_children is very inefficient

[WordPress Trac]

#3985: _get_cat_children is very inefficient
----------------------------------------------+-----------------------------
 Reporter:  ryan                              |        Owner:  charleshooper
     Type:  defect                            |       Status:  assigned     
 Priority:  low                               |    Milestone:  2.2          
Component:  Administration                    |      Version:  2.1.2        
 Severity:  normal                            |   Resolution:               
 Keywords:  2nd-opnion category optimization  |  
----------------------------------------------+-----------------------------
Comment (by charleshooper):

 For quickly and efficiently building the array I recommend we add a table
 to the schema: {{{wp_cat_hierarchy}}}

 {{{wp_cat_hierarchy}}} would consist of 2 columns: {{{parent_id}}} and
 {{{child_id}}}. There would be a unique key on the pair. This would allow
 us to quickly and efficiently build our hierarchy array.

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