Re: Oracle Server and trigger

From: PD Miller <news_watcher_at_caribdata.no_spam.demon.co.uk>
Date: 1998/03/29
Message-ID: <news_watcher-2903981334530001@caribdata.demon.co.uk>#1/1

First, look in the documentation. Application Developers Guide, and Server Concepts.

Second, triggers do slow down the server. The general rule is never to implement triggers if integrity constraints can do the same job. If you must implement triggers, do so using as little code as possible. It is more efficient to re-code large triggers as a procedure that is called from a minimalist trigger. Oracle says to limit triggers to less than sixty lines.

I will address this question more fully on my Admin Q&A page at <www.caribdata.demon.co.uk> in the next week. I hope this helps.

Regards

PD Miller

In article <3509454C.41C6_at_ex.ac.uk>, Laurent <L.Phelep_at_ex.ac.uk> wrote:

> 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 / /\/\ \

-- 
PD Miller
Carib Data Limited

Received on Sun Mar 29 1998 - 00:00:00 CST