[DUG] Why InterBase

[Paul Heinz]

Neven wrote:

>  > - BEFORE triggers
>
> In all triggers the state before and after is available hence the
> concept of before and after triggers are irrelevant

True, but if you want to reject the operation (usually to enforce a business
rule), it's much more efficient (less CPU and memory load) to abort in the
before stage than in the after stage when the database engine has gone to
all the trouble to do the actual update/insert work when you're going to NAK
it anyway.

TTFN,
  Paul.