943,633 Members | Top Members by Rank

Ad:
Jul 6th, 2009
0

question about forum design

Expand Post »
Most web forums will state next to each board how many threads or posts have been been. Would you calculate that with a query for each board to count the number of "post" entries in the table for that board, or simply increment a number in the board table whenever a new thread or post is made? I see advantages and drawbacks to both.
Similar Threads
Reputation Points: 92
Solved Threads: 51
Practically a Posting Shark
Phaelax is offline Offline
856 posts
since Mar 2004
Jul 8th, 2009
0

Re: question about forum design

I would imagine storing it somewhere would be faster since it wouldn't require a whole scan/count.
Reputation Points: 10
Solved Threads: 2
Newbie Poster
davidn is offline Offline
10 posts
since Jun 2009

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Message:
Previous Thread in Database Design Forum Timeline: MySQL on Vista server failed to start
Next Thread in Database Design Forum Timeline: How do I divide the sum of 2 columns in sql 2000 server





About Us | Contact Us | Advertise | Acceptable Use Policy
Forum Index | Build Custom RSS Feed


Follow us on Twitter


© 2011 DaniWeb® LLC