Posted by Tony Rogerson on 10/06/36 11:31

The nested set method you will see is:-

1) Difficult to maintain
2) Does not scale nor perform well out of the lab and in the real
world.

A better method is that developed by Itzik Ben Gan, information here:
http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=8826&DisplayTab=Article

The challenge is still there, you code up using the nested set model and
i'll using Itzik's method; i have a data set of over 700,000 rows which is a
message board so will be a good test.

--
Tony Rogerson
SQL Server MVP
http://sqlserverfaq.com - free video tutorials


"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:1131507918.597319.18700@f14g2000cwb.googlegroups.com...
> Get a copy of TREES & HIERARCHIES IN SQL and learn how to do it one
> simple query.
>

[Back to original message]