Re: Trigger performance

From: Keith Boulton <boulke_at_globalnet.co.uk>
Date: Sun, 19 Sep 1999 12:04:15 GMT
Message-ID: <37eb57b1.87055981@news.globalnet.co.uk>

On Tue, 14 Sep 1999 15:29:17 GMT, Alex A. <albu_at_mailcity.com> wrote:

>What is the performance impact of an insert trigger?
>I have a table
>ACTIONS(ACTION_TYPE, SOURCE, DESTINATION)
>and depending on ACTION_TYPE, DESTINATION may or may not
>be null. Is the cost of adding a trigger to enforce this
>significant (there are only about 10 action types)? If
>the overhead introduced by the trigger is significant,
>I'd rather rely on the front-end checking (although this

A check constraint should be faster:
e.g. check ( ( action_type in ( 'a', 'b', 'c' ) and destination is not null ) or ( action_type in ( 'd', 'e', 'f') and destination is null ) Received on Sun Sep 19 1999 - 07:04:15 CDT