I'm about to dig a bit deeper into Celko's articles and love the idea of nested sets. Still trying to pull some time to start implementing this myself.
Anyway, I don't really have an answer for you but you might want to take a look at PEAR::DB_NestedSet, as it sounds very able to work with nested sets. Even if you are not using php I'm sure you can pull some ideas from the code. PEAR::DB_NestedSet http://pear.php.net/package-info.php?package=DB_NestedSet Hopefully someone has some good insight :). I've read several articles explaining nested sets. but not much about working with them efficiently. olinux --- "Knepley, Jim" <[EMAIL PROTECTED]> wrote: > I'm basing some work on Joe Celko's excellent idea > of using nested sets > to represent an organizational structure as opposed > to an adjacency > list. By and large it's a great idea, but not > without its pitfalls. I'm > writing now to ask your collective opinion of the > best practice. __________________________________ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]