Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Triggers : Performance Trade Off?

Re: Triggers : Performance Trade Off?

From: Ian Cary <cary_at_gatwick.geco-prakla.slb.com>
Date: 1997/09/16
Message-ID: <341E4155.4697@gatwick.geco-prakla.slb.com>#1/1

> > I am wondering, was the avoidance of triggers due to a performance
> > issue?

Prior to v7.3 triggers had to be re-parsed at execution time whereas packages + procedures remained parsed in the SGA. Triggers were therefore less efficient and it was common practise to code most routines as packages and procedures and only use triggers to call these routines, rather than have have the routines within the trigger itself.

Regards,

Ian Received on Tue Sep 16 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US