Subject | RE: [firebird-support] Calcurate row size |
---|---|
Author | Helen Borrie |
Post date | 2004-07-13T08:47:18Z |
At 05:49 PM 13/07/2004 +1000, you wrote:
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
> > Blobs and arrays aren't stored with the row. Allow 4 bytes per blob_id.Not actually, since the maximum number of rows in a table is an integer,
> >
> > 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 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