Subject Re: [firebird-support] Maximum number of stored procedures?
Author Helen Borrie
At 11:33 PM 4/09/2005 +0000, you wrote:
>Is there a limit to the number of stored procedures which can be
>contained within a single FB db?

The theoretical limit is rather large. It's approximately 2.1 billion
(international/mega-million) divided by the total number of arguments
passed both ways to/from all of the procedures.

>While I'm on the topic, are there any
>limits to the number of other db items, eg generators etc?

Sure. Ask. A generator is a signed BigInt and will "run out" after the
18,446,744,073,709,551,615th number has been generated. Of more interest
is that you can't have close to that number of records or unique serial
numbers in a single table. It's currently limited to around 2.1 billion,
including uncollected garbage and uncommitted work. It will be less if the
row size spreads across more than one database page and/or contains blobs
that could fill multiple pages. So you do need to think about history
tables for big tables...