Subject Re: [firebird-support] Re: "Generators" via table data
Author Paul Vinkenoog
Ann W. Harrison wrote:

> Woody wrote:
>>
>> How small is small? 4096? I think that's what most of my earlier
>> databases were created with, IIRC.
>>
>
> 4096 should give you about 500 generators, after subtracting the
> page header.

And like you said, the limit was lifted before Firebird 1.0, so for
any released Firebird version it's (almost) 32K.

Woody, watch out with InterBase: versions up to (at least) 6.0.1 will
let you "create" nearly 32K generators without warning, but only the
first couple hundred are really established. The rest is outside the
database or on pages used for other nice things (like storing data).
The result: error messages during access and/or silent database
corruption.

See also
http://www.firebirdsql.org/manual/generatorguide-basics.html#generatorguide-basics-howmany


Greetings,
Paul Vinkenoog