Discussion Forum Design

[stu]

http://www.sqlteam.com/item.asp?ItemID=1353

About to start a very similar project. Does any body have any comments
about this design compared to other tree implementations?

I think it is a good idea having everything geared up to retrieve data in
this situation. There is going to be a higher expected response time
associated with posting compared with a query to get for example the last
weeks posts.

Something this article ignores is that we don't need to retrieve all posts
initially. We could get away with just fetching the 1st post in each thread
and fetch its replies when requested.

I imagine there will be a high number of posts (1,000,000 /year) 90% of
which, will have 1 reply, the other 10% could have over 100 replies.

Cheers
Stu