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.