Brian,
> On the Celko note - has anyone implemented his nested tree model? It's
> really great for arbitrarily deeply nested hierarchies.
I have. I find it really, really fast for "in branch" queries (which other
trees suck at) but really, really slow to update. So it's a good model for
a tree which will be modified, say, once every 10,000 reads.
--
-Josh Berkus
Aglio Database Solutions
San Francisco