[wp-trac] Re: [WordPress Trac] #3985: _get_cat_children is very
inefficient
WordPress Trac
wp-trac at lists.automattic.com
Thu Mar 22 07:08:51 GMT 2007
#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
More information about the wp-trac
mailing list