Subject | Re: Maximum fields per table |
---|---|
Author | nopaintnogain2006 |
Post date | 2009-01-06T06:24:57Z |
thanks you
-- In firebird-support@yahoogroups.com, "Dean Harding"
<dean.harding@...> wrote:
-- In firebird-support@yahoogroups.com, "Dean Harding"
<dean.harding@...> wrote:
>each
> > > 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
> 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.
>