| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Triggers Performance cost
Ilias Santouridis wrote:
>
> Hi
>
> we want to perform value auditing in the application we're developing.
> We plan to use triggers for that purpose.
>
> What is the performance overhead that the usage of triggers will cause ?
> We plan to audit about 40 tables and we need at least 3 triggers per
> table. The audited tables will be updated very frequently.
>
> I would like to thank you in advance.
>
> Regards,
> Ilias
Of course there is a performance penalty but no more than if you coded the auditing yourself in the application....
We've has some apps in the past that we changed to move our auditing and other business rules into triggers and the different in performance was negligible...
HTH --
 |
 |