Re: 2 triggers or 1??

Thanks everyone. I've written up the code and will do as Pete suggests to test both cases and see for myself. Now... it's off to learn a bit about tkprof and trace files...and coffee...mmm.

thanks,
A

Pete Finnigan wrote:
> Hi,
>
> Simply test both cases, write one version with two triggers and a
> version with one trigger and run a SQL trace on both and read the trace
> files, either using tkprof or simply read through the raw trace.
>
> I have not tried it but i would assume there would be more recursive SQL
> with two triggers as Oracle needs to set up two triggers to run and at
> least the call to the PL/SQL that the trigger executes will be double.
> Logically thinking about it i would assume one trigger to perform better
> performance wise, but whether it is better business logic wise is
> another matter. Try it and see!
>
> I always find testing things for myself to be more satisfying as you get
> to see how things work and understand why one method is faster than
> another for instance.
>
> hth
>
> kind regards
>
> Pete
Received on Wed Mar 17 2004 - 16:53:29 CST