Subject Re: [firebird-support] Max number of fields in a table
Author Daniel Rail
Hi,

At February 24, 2005, 13:10, Richard wrote:

> Is there a max limit, or recommended limit of the number of fields in a
> table, or does it not really matter. I'm sort of thinking a bit over a
> hundred.

The number of fields is directly related to the total number of bytes
per row. The maximum number of bytes per row is 64KB. Do note that for
BLOBs, only count the pointer length, not the segment.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)