Subject Re: [firebird-support] Maximum size for trigger script?
Author Ann W. Harrison
Brenden Walker wrote:
> I'm guessing it's 65535 or thereabouts, and I took a quick look in 'the
> book' and the limits appendix doesn't seem to have this.
>

The blr (semi-compiled form) of the procedure is limited to 64Kb.
There's no real way to predict whether the blr will be larger or smaller
than the text - names expand, operations contract ...

However, a procedure can invoke another procedure with little or no
performance cost, so why not try modularity?


Regards,


Ann