Subject Re: [firebird-support] Triggers in Firebird, why row based?
Author Fabricio Araujo
Em 03/07/2011 15:25, firebirdsql escreveu:
> Every database venders seems to implement triggers per set operation, in
> Firebird, it's the opposite where a trigger fires per every row in the
> set. This really complicates a lot of things (besides performance). Is
> there any plan to introduce set based triggers in the future etc?

What? AFAIK, only Sybase and MS SQL Server does use per operation
triggers. Even Oracle triggers row row based.

Row based really simplifies the implementation code. In contrast, per
operation triggers are easier to screw up things (mainly performance)
and harder to get it right.