Обсуждение: Number of fields in a record

Поиск
Список
Период
Сортировка

Number of fields in a record

От
JORGE MALDONADO
Дата:
I am designing a table which will have about 70 fields per record and I wonder if this is a big number. The data types are boolean, varchar(maxlength), time, integer, smallint and numeric mainly.
I will appreciate your comments to this respect.
 
Respectfully,
Jorge Maldonado

Re: Number of fields in a record

От
Kenneth Marshall
Дата:
On Wed, Jan 05, 2011 at 02:20:32PM -0600, JORGE MALDONADO wrote:
> I am designing a table which will have about 70 fields per record and I
> wonder if this is a big number. The data types are boolean,
> varchar(maxlength), time, integer, smallint and numeric mainly.
> I will appreciate your comments to this respect.
>
> Respectfully,
> Jorge Maldonado

No, that is not a large number of fields. It is usually more
important that the table schema be normalized.

Cheers,
Ken