Subject | RE: [firebird-support] Re: Maximum fields per table |
---|---|
Author | Dean Harding |
Post date | 2009-01-06T02:21Z |
> > That said, you will hit the limit pretty fast with e.g. twoThe math is pretty basic. The maximum record size is ~64K as was already
> > 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?
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.