| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| Technology & Technical Skills Computer skills, hardware, software, internet topics, gadgets, programming |
|
Welcome to the Personal Development for Smart People Forums, the place for lively, intelligent discussion of all personal growth issues -- physical, mental, financial, social, emotional, spiritual, and more. You're currently viewing as a guest, which gives you limited read-only access. By joining our free community, you'll be able to post your own messages, access many members-only features, see the new messages posted since your last visit, and of course remove this header message. Registration is fast, simple, and free, so please join today. If you arrived here from a search engine, you may want to explore the main site first, which includes hundreds of deep and insightful articles on a variety of personal development topics. |
 |
| | Thread Tools | Display Modes |
04-06-2008, 08:06 AM
| |||
| |||
 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
| |||
| |||
| 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.
__________________ toby hede --------------- Toby Hede’s Blog on Ruby, Rails, User Experience and Stuff |
|
04-06-2008, 02:55 PM
| |||
| |||
| Going to have to agree with toby on this one. You should only need one table for the message specifics. |
|
04-07-2008, 10:22 PM
| |||
| |||
| Sounds good. |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| 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 |
| Website vs. Blog (Steve please comment ...) | brooksr | Technology & Technical Skills | 2 | 07-28-2007 07:57 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 05:01 AM.