Re: Triggers or application code? Which is more efficient?

Hi,

    Since triggers are application code, did you mean Constraints defined at the time a table is created sucha as Referential Integrity Constraints? Constraints are more efficient than application code.

    Except for Referential Integrity which makes it more tedious to do things like imports and data loads since tables have to be loaded in order (or the referential integrity constraints disabled and then reenabled after the operation is performed) there are no significant costs.

    IMHO the major benefit is better protection against "Garbage In" since the constraints can reflect the business rules and no coding is necessary to enforce them. Another major benefit is that the application code process is simplified since the applications need not include the functions provided by the constraints. This results in smaller, cleaner code modules that are faster to write and debug and maintain over the life of the application.

regards
Jerry Gitomer

ahcarson_at_bglasscity.cnet wrote in message <3783513a_at_news.glasscity.net>...
>
>Triggers or application code? Which is more efficient?
>
>What are the costs/benefits of triggers vs. adding code to
>dataload software to support more complex integrity checks?
>
>Any thoughts on which is more effecient?
>
>Howard (remove 'a' 'b' 'c' to email)
Received on Thu Jul 08 1999 - 07:36:51 CDT