On Mon, 13 Jun 2005 13:14:42 -0400, Ann W. Harrison wrote:

>marius popa wrote:
>
>> from the paper i see firebird 1.5.2 still have some limits
>
>The major limit in Firebird 1.5.2 is the the length of the index key.
>The next most important is that the db_key is 32 bits and db_keys are
>not dense, so a table with somewhere between 40 and 70 Gb of data, runs
>out of db_keys. Both of those are fixed in FB2 - index keys up to 1/4
>of a database page and 40 bit db-keys. Note, though, that neither of
>those is "unlimited". And do remember that our page numbers are also 32
>bits, so the largest possible database has 4Gb of 16Kb pages... that's
>big, but not "unlimited".

This means:

Maximum Database size: 64Tb
Maximum DB-Keys (per relation): 1 Gb

Wow... Even the bigger DB I worked so far (in MSSQL) don't even
get near to it... ;-)