Re: Oracle Server and trigger

Before 7.3 best performace was gained by calling a strored procedure from the trigger becuase triggers were not compiled, Triggers are compiled from 7.3 onwards so perform similarly to stored procedures. From 8.0 PL/SQl becomes a first class citizen, i.e. SQL and PL/SQL have similar performance.

Regards
David Russell
Laurent wrote in message <3509454C.41C6_at_ex.ac.uk>...
>Hi,
>
>
>
>I am doing some research about trtigger in Oracle.
>
>
>Can anybody tell me where I could find information about the
>performances of Trigger in Oracle : if they slow down the server and
>what has to be done to avoid it .......?????
>
>I desperately need these information, so if you have only one link
>thanks to send it to me.
>
>
>Thanks.
>
>
>Laurent
>
>Laurent PHELEP /\
>Third Year Student in Computer Science \/
>University of Exeter <> <>
>Email : L.Phelep_at_ex.ac.uk /\
>http://www.dcs.exeter.ac.uk/ug/cs95/lp/ / \
> / \
>Kenavo / /\/\ \
Received on Sat Mar 14 1998 - 00:00:00 CST