Ivan,

> > Is there a limit to the number of stored procedures which can be
> > contained within a single FB db?
>
> Because RDB$PROCEDURE_ID is just SMALLINT,
> 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
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com