Subject Re: [firebird-support] Table restrictions regarding field count / field type?
Author unordained
---------- Original Message -----------
From: "patrick_marten" <patrick_marten@...>
> are there any restrictions for tables regarding field count and/or
> count of fields with a certain datatype?
>
> For instance:
> would it be problematical to have a table with let's say 170 fields,
> 40-60 of which are blob fields of subtype 0?
>
> Also considering the recordcount, so that once such a table contains a
> certain number of records, the database says "table too big" or
> something like that?
>
> Regards,
> Patrick
------- End of Original Message -------

Please see http://www.firebirdfaq.org/faq61/

The blobs won't be a problem, but the 120 other fields might be, depending on
their types?

-Philip