> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
> Sent: Wednesday, July 20, 2005 4:06 PM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Maximum size for trigger script?
>
> 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?

Thanks, we worked around the problem for now by dropping indenting and
extra spaces around operators (saved 10k on a 69k script). Not sure how
this type of thing would divide up, but certainly worth looking into.