| |||||||
| Technology & Technical Skills Computer skills, hardware, software, internet topics, gadgets, programming |
 |
| | Thread Tools | Display Modes |
04-06-2008, 08:06 AM
| #1 (permalink) |
| Member Join Date: Mar 2008
Posts: 46
 |  Mysql comment tables
I'm working on a website with PHP and Mysql and wanted to know if it is better to have one comment/guestbook database table (which will store hundreds/thousands of comments) or have one comment/guestbook table for each article. Having one comment/guestbook table would be easier to manage/create, but may cause the website to lag. Anyone have experience with a comment/guestbook Mysql table? |
|      |
|
04-06-2008, 10:39 AM
| #2 (permalink) |
| Senior Member Join Date: Nov 2006 Location: Melbourne, Australia
Posts: 182
|
The whole benefit of using a relational database is to have one table for each one of the entities in your system. It will not cause any performance issues. The only case I've heard where breaking a system into individual tables was required is with wordpress.com ... they have 1,000,000 blogs and INSANE amounts of traffic, and I believe each blog has it's own tables. However, this decision was made because of very specific architectural concerns. |
|
| |
|
| Bookmarks |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Website vs. Blog (Steve please comment ...) | brooksr | Technology & Technical Skills | 5 | 01-28-2009 08:25 PM |
| Dare ya to comment! | The Flannel Guy | Social & Relationships | 29 | 01-25-2008 05:50 PM |
| Pl comment on my Christmas Theme! | RichGrad | Technology & Technical Skills | 0 | 12-06-2007 02:06 AM |
| Comment on my workout routine | ArtVandelay | Health & Fitness | 7 | 09-22-2007 09:36 PM |
| Any PhP/mySQL gurus out there? | trekr5 | Technology & Technical Skills | 20 | 01-10-2007 11:05 PM |
All times are GMT. The time now is 12:11 PM.