At 11:48 AM 5/25/2004, Eduardo Gamboa wrote:

>Ann,
>
>My tables have 2 integer fields, one timestamp field, one varchar(16), one
>varchar(48), one char(1) and one Blob field subtype 0 segment size 80
>(used for images).
>
>I would like to know what would the max table size be?

Eduardo,

Blobs, regardless of size, take only 8 bytes in the
record and the limit is on record numbers. My guess is
that your compressed records will be about 50 bytes long
- maybe a bit longer depending on the use of the
varchar(48). That will allow you to store about 50Gb
of compressed data in the record plus whatever space the
blobs actually take.

As I said earlier, an upcoming version of Firebird
will implement a larger record number, and eliminate the
practical limit on table size.


Regards,


Ann