> -----Original Message-----
> From: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
> Steinmaurer
> Sent: Thursday, July 21, 2005 1:58 AM
> To: firebird-support@yahoogroups.com
> Subject: Re: [firebird-support] Maximum size for trigger script?
>
> > Brenden Walker wrote:
> >
> >>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.
> >>
> >
> > So apparently the blr was smaller than the source - I'm not
> sure where
> > the limit on the source comes from...
>
> The maximum size of one SQL statement in Firebird counts here then.
> AFAIR it is 64Kb.

That's probably the 'wall' that I hit. These triggers are generated in
code and get very large due to needing to compare old.field with
new.field for all fields.. And this particular table is getting rather
large field wise. After removing the 'pretty pretty' indenting and
spacing around operators and the like.. I bought us some time.. We have
plans to rewrite this part of the system anyway (dealing with
replication) which will solve the problem.

Thanks everyone for the info on the subject.