Got it. Nested set trees are very, very cool. Wow! Thanks for that. The efficiency with which you could select siblings/parents/ancestors and subtrees is crazy, recursive queries always bugged me (I've implemented parent-child relationships before).
It's a bit hard to wrap my head around how to get it into code, but I can probably come up with something given the SQL in the article.
I need to figure out now if speed of execution outweighs speed of development, and figure out where I'm going to spend my time.
-Any sufficiently advanced technology is
indistinguishable from doubletalk.
|Replies are listed 'Best First'.|
Re: Re: Re: Recommended modules for Parent-Child trees?
by stvn (Monsignor) on May 18, 2004 at 13:51 UTC
by Hero Zzyzzx (Curate) on May 18, 2004 at 14:41 UTC