Subject RE: [firebird-support] Generators
Author Helen Borrie
At 10:45 PM 9/09/2003 +1000, you wrote:
> > >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.
> >
> > heLen
>But what, if any, performance hit is there for using a 16k page size versus
>a 4K page size?

That's not something you can predict without knowledge of the row sizes of
your most-frequently accessed tables. You choose a page size to suit your
tables, not as a way to stuff more generators into the system...

Regarding the allocation of more pages for generators - I'm posting a Q in
devel to check whether it was actually implemented in 1.5 and whether it
was, or will be, backported to 1.0.x.