question about forum design

Reply

Join Date: Mar 2004
Posts: 763
Reputation: Phaelax is on a distinguished road 
Solved Threads: 38
Phaelax Phaelax is offline Offline
Master Poster

question about forum design

 
0
  #1
Jul 6th, 2009
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.
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 10
Reputation: davidn is an unknown quantity at this point 
Solved Threads: 2
davidn davidn is offline Offline
Newbie Poster

Re: question about forum design

 
0
  #2
Jul 8th, 2009
I would imagine storing it somewhere would be faster since it wouldn't require a whole scan/count.
http://www.raima.com for all your embedded and real-time database needs.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Database Design Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC