Hi Philip,

thanks for the link - a very useful article!

Right now the biggest table I have contains 146 fields:
21 blob fields (= 84 bytes? as only BLIB_ID is being stored)
6 decimal (5,2) fields (= max. 48 bytes)
29 double precision fields (= max. 232 bytes)
8 integer fields (= 32 bytes)
8 numeric (18,2) fields (= max. 64 bytes)
22 smallint fields (= 44 bytes)
5 timestamp fields (= 40 bytes)
49 varchar fields of different lengths (total max. length 3377) (= max. 13508 bytes due to UTF8)

If my calculation is correct, all together we have here 14052 bytes = ~14kB. Then there would still be a lot of reserve...

Is that correct?

Regards,
Patrick

--- In firebird-support@yahoogroups.com, "unordained" <unordained_00@...> wrote:
>
> ---------- 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
>