Subject RE: [firebird-support] Calcurate row size
Author Helen Borrie
At 05:49 PM 13/07/2004 +1000, you wrote:
> > Blobs and arrays aren't stored with the row. Allow 4 bytes per blob_id.
> >
> > Plus, for each row, 2 bytes to store the db_key and the row offset (or is
> > it 4 bytes?)
> >
> > /heLen
>
>and if all rows in a table with BIGINT primary key (full to capacity) has a
>blob field - how does only 4 bytes locate the blob? sounds like a wrapping
>problem???

Not actually, since the maximum number of rows in a table is an integer,
not a BigInt. That is, you couldn't have a table that had one value for
every possible BigInt whereas (at least in theory) it would be possible to
have one row for every possible 32-bit integer.

/hb