Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
j2bailey
Starting Member
2 Posts |
 Posted - 2001-05-18 : 13:29:06
|
| I have developed a Forum on my personal page as a way to keep in touch with some friends. However I didn't anticipate that they would be using it as much as they are. So now, I have a lot of messages. This is the problem: the high number of messages is making my page really slow.So now I'm trying to come up with a new design that would make my pages faster. The look of the page is a little similar to the EI News - with the available forums and topics on the left and the all the message headers being displayed on the top right. I display these messages headers as threaded ( ie - you can see who responded to what message under each topic ) And I believe this is the part that is taking up a lot of time -> since, for each message I have to check if it has "childrens", if it does I display them and check if the "childrens" have "childrens". You see how this recursive call can become very costly.So currently my table that keeps the messages has an ID , a parentID, and other information. I'm trying to think of a way to avoid these recursive calls. I haven't thought of any other feasible solution that has no limitations on the number of childrens a message can have. Does anyone have any suggestions (how to make the current structure faster, a new design, things to look into.. anything)?Thanks for you time,Jen |
|
|
|
|
|
design for a Forum tool???