id	summary	reporter	owner	description	type	status	priority	milestone	component	version	severity	resolution	keywords	cc
3985	_get_cat_children is very inefficient	ryan		"_get_cat_children is slow and stupid.  Doing DB queries to get the children of each cat is faster than using _get_cat_children.

One proposal is to store an array that contains the hierarchy.  array(parent => child, child => grandchild).  Categories that have no children would not be present in the array.  The drawback is that this would require keeping the array in sync with category changes.  Any other suggestions to make creating the hierarchy more efficient while minimizing DB queries?"	defect (bug)	closed	high	2.2	Administration	2.1.2	major	fixed	2nd-opnion category optimization hit-list	charleshooper