Discussion Forum Design

From: stu <smcgouga_at_nospam.co.uk>
Date: Thu, 24 Apr 2003 14:31:53 +0100
Message-ID: <b88p44$bpa$1$8302bc10@news.demon.co.uk>

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 Received on Thu Apr 24 2003 - 08:31:53 CDT