Subject Re: [firebird-support] Generators
Author Lucas Franzen
Helen Borrie schrieb:

> At 10:55 AM 9/09/2003 +0000, you wrote:
>
>>Hi
>>
>>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.

In the pre-64bit times there were these limitations depending ont he
pagesize of the db.

VERSION 1K 2K 4K 8K
Pre-V6 248 504 1016 2040
V6 124 257 508 1020

(this is what Ann wrote in October 2000)

I'm not sure about the limitations (if there are any and if so which)
within FB1.5

Luc.