Thanks Ann!

That is exactly what I was looking for.

best regards

Dalton

Ann W. Harrison wrote:

>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
>
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Visit http://firebird.sourceforge.net and click the Resources item
>on the main (top) menu. Try Knowledgebase and FAQ links !
>
>Also search the knowledgebases at http://www.ibphoenix.com
>
>++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>
>