RE: Hom many columns is too many?

2001-05-14 Thread Robert Henkel
. -Original Message- From: ryc [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 4:09 PM To: [EMAIL PROTECTED] Subject: Re: Hom many columns is too many? Just because one table has many columns does not mean it is not normalized. The original message stated that there is all kinds of different

Re: Hom many columns is too many?

2001-05-14 Thread Gary Bickford
they be broken up. I've noticed in the past some speed issues when you have too many columns. - Original Message - From: Richard Reina [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 11, 2001 11:26 AM Subject: Hom many columns is too many? I am designing an in house database

Re: Hom many columns is too many?

2001-05-14 Thread Jeremy Zawodny
On Mon, May 14, 2001 at 03:51:00PM -0700, Gary Bickford wrote: Personal data databases often seem to have variable information that doesn't fit all that well in relational databases. For example, multiple phone numbers for different purposes. Create a table with three columns. (1) And id

Re: Hom many columns is too many?

2001-05-12 Thread Richard Reina
the way to where they went to high school could be stored in one table logically or more importantly efficiently. -Original Message- From: ryc [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:58 AM To: 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Hom many columns is too

Hom many columns is too many?

2001-05-11 Thread Richard Reina
I am designing an in house database app. for sales/contact management. We've identified out about 75 things to know about a customer/contact from there name all the way to where they went to highschool. Should all these attributes be in one table since they all describe the contact or should

RE: Hom many columns is too many?

2001-05-11 Thread Robert Henkel
, May 11, 2001 1:26 PM To: [EMAIL PROTECTED] Subject: Hom many columns is too many? I am designing an in house database app. for sales/contact management. We've identified out about 75 things to know about a customer/contact from there name all the way to where they went to highschool. Should all

Re: Hom many columns is too many?

2001-05-11 Thread Eric Fitzgerald
I would personally suggest they be broken up. I've noticed in the past some speed issues when you have too many columns. - Original Message - From: Richard Reina [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 11, 2001 11:26 AM Subject: Hom many columns is too many? I am

Re: Hom many columns is too many?

2001-05-11 Thread ryc
too. Its an art not a science:) RH -Original Message- From: Richard Reina [mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 1:26 PM To: [EMAIL PROTECTED] Subject: Hom many columns is too many? I am designing an in house database app. for sales/contact management. We've

RE: Hom many columns is too many?

2001-05-11 Thread Robert Henkel
[mailto:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:58 AM To: 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Hom many columns is too many? I dont think the problem was redudant data. He is talking about 75 distinct fields that no other table contains and ALL data is related to the contact

Re: Hom many columns is too many?

2001-05-11 Thread ryc
:[EMAIL PROTECTED]] Sent: Friday, May 11, 2001 11:58 AM To: 'Richard Reina'; [EMAIL PROTECTED] Subject: Re: Hom many columns is too many? I dont think the problem was redudant data. He is talking about 75 distinct fields that no other table contains and ALL data is related to the contact