I decided to break it into 2 tables and
every thing work okay.
Thanks for the help
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Albert
Berry
Sent: Monday, 13 September, 2004
10:06
To: RBG7-L Mailing List
Subject: [RBG7-L] - Re: Number of
Columns in Table
The error is not the number of columns but the total
bytes per row. There is a 4k restriction on row width. There is also a saying
in any SQL database that it is better to have many skinny tables than few fat
tables.
How many of the columns in your table will be more
often NULL than populated with data? This is a good test to see which columns
should be moved to a child table.
[EMAIL PROTECTED]
wrote:
I keep getting an error on adding
more than 99 columns to a table. The error is -ERROR- Row length exceeds maximum
of 4,096 characters (2370). I did not realize that there was a table
restriction. Is this correct?
Chuck Conrad
Albert Berry
Management Consultant
RR2 - 1252 Ponderosa Drive
Sparwood BC, V0B 2G2
Canada
(250) 425-5806
(250) 425-7259
(708) 575-3952 (fax)
[EMAIL PROTECTED]
|
