Subject | Re: [firebird-support] Maximum number of stored procedures? |
---|---|
Author | Ivan Prenosil |
Post date | 2005-09-05T09:01:19Z |
> Is there a limit to the number of stored procedures which can beBecause RDB$PROCEDURE_ID is just SMALLINT,
> contained within a single FB db?
the maximum number of procedures is 64k.
(and you better try it, just in case there could be a bug
limiting the number to just 32k).
> While I'm on the topic, are there anyCheck system tables. E.g. RDB$GENERATOR_ID is SMALLINT too,
> limits to the number of other db items, eg generators etc?
so the limit is the same.
Ivan