Subject | Re: [firebird-support] Triggers in Firebird, why row based? |
---|---|
Author | Fabricio Araujo |
Post date | 2011-07-03T22:57:25Z |
Em 03/07/2011 15:25, firebirdsql escreveu:
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.
> Every database venders seems to implement triggers per set operation, inWhat? AFAIK, only Sybase and MS SQL Server does use per operation
> 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?
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.