Subject Re: Maximum fields per table
Author nopaintnogain2006
thanks you
-- In firebird-support@yahoogroups.com, "Dean Harding"
<dean.harding@...> wrote:
>
> > > That said, you will hit the limit pretty fast with e.g. two
> > > VARCHAR(32000) and some additional fields. You won't hit the limit
> > > that fast with only Integer fields.
> >
> > is there an easy :-) way to calculate it?
>
> The math is pretty basic. The maximum record size is ~64K as was already
> mentioned. Therefore, you just need to add up the size (in bytes) of
each
> column you want. If it's > 64K, it's too big. If it's less then you're
> (probably) OK.
>
> The real question is, why does it matter to you?
>
> Dean.
>