Dalton Calford wrote:

> Sorry to bother you guys with this, but I forgot the table limits in
> firebird 1.5x or below.
>
> I need to know the row count/table size limits.

Prior to Firebird 2, the record number is a 32 bit integer,
so there's a hard limit of 4G of records. However, the
record name space is not dense - part of it is the number
of records on a page which varies in life, but is fixed as
a portion of the record number. The fixed portion is
enough to allow a full page of zero length records.

Regardless of your page size, if your average stored
data length is 10 bytes, you can store 2,704,238,667
records. With a data length of 50 bytes you can store
1,089,767,821 records. With a data length of 100 bytes
you can store 624,055,077 records.

The stored size of data is not the same as the original
size, due to compression.

V2 has a forty bit record number. Eight more bits makes
all the difference in the world.

Regards,


Ann