Posted by hornedw on 09/02/06 04:48

mootmail-googlegroups@yahoo.com wrote:
> Jerry Stuckle wrote:
> >
> > If you can do recursive queries, it works quite well. And this was with
> > DB2, which handles recursive queries quite well.
> >
>
> Hmm. The DB we were using didn't support recursive queries, so I never
> got to explore that path, unfortunately. I suspect that, as you say,
> it would handle well enough performance-wise, seeing that all the
> recursing is done on the DB itself rather than via recursive queries
> coming from the code. Still, though, even the most efficient recursion
> carries along with it some degree of overhead. That's just the nature
> of recursion.
>
> If I had the time spare time, I would love to implement a number of
> tree algorithms and see how they scale in performance as the size of
> the tree increases. That is the kind of assignment I WISH they had
> given back in college. Practical and educational.

Thanks everyone for your help. I probably will either use Javascript or
CSS in displaying the child categories or set it up similar to
Amazon.com's categories(main categories display on one page, and the
category selected and its subcategories on the second page. Thanks
mootmail--I will look back at the link I provided earlier as to display
the number of items.

David

[Back to original message]