| Posted By |
Discussion Topic: How many columns are too much
|
|
louissto56 |
10-27-2007 @ 4:52 AM |
|
|
Moderator
Posts: 1149
Joined: Jan 2007
|
I am in the middle of designing my database and I think I have a bit too many columns but I don't really want to make another table. I have 12 at the moment 
What does everyone else think? How many columns are too much? What is the most columns you've ever seen in a table.
Post your traumatic experiences here:
|
|
louissto56 |
|
10-27-2007 @ 5:22 AM |
|
|
Moderator
Posts: 1149
Joined: Jan 2007
|
I am posting here so I can be the 4444th person to post in the General Discussion area. What an honor!! Ill expect my prize in the mail by tuesday, pablo.
Notice-Board in NZ has now been released. Check it out at www.notice-board.co.nz !!
|
|
Webmaster |
|
10-27-2007 @ 1:23 PM |
|
|
Administrator
Posts: 4533
Joined: Jan 2002
|
LMAO your prize is being the 4444th person.. isn't that rewarding enough? 
Pablo Varando 
Senior Application Architect
EasyCFM.COM, LLC.
904.483.1457 \\ mobile
webmaster@easycfm.com \\email
|
|
steini |
|
10-27-2007 @ 4:10 PM |
|
|
Junior Member
Posts: 52
Joined: Oct 2005
|
I think no,
i think louissto56 must spend us all a nice evening with countless food and wine and sweet girls.... 
- Steini - www.cfscout.com
|
|
louissto56 |
|
10-27-2007 @ 7:02 PM |
|
|
Moderator
Posts: 1149
Joined: Jan 2007
|
No prize? Fine. Just put me in the EasyCFM hall of fame or something hehe
@steini the sweet girls I can do, but the countless food and wine! You're crazy man. CRAZY
This is all off topic you know. I came here for advice not to be ridiculed
Notice-Board in NZ has now been released. Check it out at www.notice-board.co.nz !!
This message was edited by louissto56 on 10-27-07 @ 7:03 PM
|
|
jarottman |
|
10-29-2007 @ 12:25 PM |
|
|
Senior Member
Posts: 679
Joined: Sep 2004
|
It really depends louiss. Do any of the columns you have not hold similar data? Ie Home Phone, Work Phone, Mobile Phone, Fax Phone, X Phone, Y Phone?
Generally when I create a table and there is more then 3 columns that will hold similar data, I will create a new table to hold that data.
I always trying to keep my tables at or below 15 columns. If I know it is going to require more, I split it up into two or more tables.
cflock of seagulls?
|
|
louissto56 |
|
10-31-2007 @ 5:27 AM |
|
|
Moderator
Posts: 1149
Joined: Jan 2007
|
Yeah well none hold the same data. I think 12 is ok.
Notice-Board in NZ has now been released. Check it out at www.notice-board.co.nz !!
|
|
Scarecrow |
|
10-31-2007 @ 6:27 PM |
|
|
Junior Member
Posts: 109
Joined: Oct 2004
|
The whole question is moot. Any database should be normalized and thus the column count is irrelevant.
Ken
www.krcaldwell.com
|
