Trigger performance

From: Alex A. <albu_at_mailcity.com>
Date: Tue, 14 Sep 1999 15:29:17 GMT
Message-ID: <7rlpju$mls$1@nnrp1.deja.com>

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 is not the right thing to do...).

Any advice?

Thanks,
Alex

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Tue Sep 14 1999 - 10:29:17 CDT