| | |
question about forum design
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Mar 2004
Posts: 763
Reputation:
Solved Threads: 38
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.
•
•
Join Date: Jun 2009
Posts: 10
Reputation:
Solved Threads: 2
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.
![]() |
Similar Threads
- Database Design Question (Database Design)
- Question about forum etiquette (Community Introductions)
- newbie question about database design (Computer Science)
- Forum Design: Best for user customization (IT Professionals' Lounge)
- Forum lurkers, introduce yourself ... !! (Community Introductions)
- Large and tables/cells..how? (HTML and CSS)
- Question (Geeks' Lounge)
Other Threads in the Database Design Forum
- Previous Thread: Timetable for school department
- Next Thread: How do I divide the sum of 2 columns in sql 2000 server
| Thread Tools | Search this Thread |





