Subject | Re: [firebird-support] Re: "Generators" via table data |
---|---|
Author | Paul Vinkenoog |
Post date | 2007-01-29T23:27:33Z |
Ann W. Harrison wrote:
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
> Woody wrote:And like you said, the limit was lifted before Firebird 1.0, so for
>>
>> 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.
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