Subject Re: [firebird-support] Generators
Author Helen Borrie
At 10:55 AM 9/09/2003 +0000, you wrote:
>Whats the limit of generators a DB can have ?

I believe it depends on your page_size. I'm pretty sure that, for IB and
for Fb 1.0.x, you are limited to the number of generators that can fit on
one page. There was talk of increasing the number of pages for Fb 1.5, so
I must make a note to inquire whether it was done.

If Ann is watching, she will give you the exact numbers. I *think* each
generator takes up ~40 bytes: 8 bytes for the number and 32 bytes for the
identifier. You'd need to allow some bytes for the page header (Ann?),
which seems to give you a limit of about 200 for an 8K page, i.e. the
64-bit generator halved the previous limit.

>Does it affect the system in any way, if I have many generators (in
>my DB many is 200 - 400).

Assuming you have a 16K page_size, no, ~400 should be OK. There's no
additional performance overhead that I'm aware of.