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