I saw some info around (in the MySQL manual there's something about it), but i can get a straihgt answer...
How big is big?
I mean, does a table with around 150-170 columns considered big?
Should i break it in several different tables?
Up-side is that in more then half the pages only 1 query would occour.
In several tables, several queries would occour...
Any info on this?
Thanks.
Table: how big is big? (in columns...)
Moderator: General Moderators
- mydimension
- Moderator
- Posts: 531
- Joined: Tue Apr 23, 2002 6:00 pm
- Location: Lowell, MA USA
- Contact:
it really depends on what you are doing with the information. for mw i try to make my tables small using foreign keys to cross link information. this in turn gives me fewer columns in return for a few more tables (depends on the application). newbienetwork has a good databse design tutorial that could help you out.
do i guess in answer to your question: there is no limit really. i guess a good rule of thumb would be: its too big if you don't want to writee the long qury to get the information you need.
do i guess in answer to your question: there is no limit really. i guess a good rule of thumb would be: its too big if you don't want to writee the long qury to get the information you need.
- mydimension
- Moderator
- Posts: 531
- Joined: Tue Apr 23, 2002 6:00 pm
- Location: Lowell, MA USA
- Contact: