Subject Re: [firebird-support] Maximum number of stored procedures?
Author Martijn Tonies

> > Is there a limit to the number of stored procedures which can be
> > 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 any
> > limits to the number of other db items, eg generators etc?
> Check system tables. E.g. RDB$GENERATOR_ID is SMALLINT too,
> so the limit is the same.

This isn't true - there's another limit to the number of generators
which has to do with the (generator) page size of a database, so
the limit is a per-database specific thingy.

But I cannot remember exactly how and why... :-)

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Upscene Productions
Database development questions? Check the forum!