Trigger Gotcha & Question

[John Carr <74711.77@xxxxxxxxxxxxxx>]

:       Trigger Gotcha & Question
<SNIP>
>Now the question, is anyone aware of any performance implications of
>using triggers? I realize a crappy trigger program will drag you down,
>but has the trigger process itself caused any problems at your site?
>Bob Larkin

Bob we have about 50 of them on "Major files" at 6 of our plants.  They 
are used to forward updates to a central AS/400 in a real 24/7 environ.
They work great, No problems, NO noticable performance problems.
Yes, you have to have a "Exclusive Lock" to change them etc.  But you
should think of them as an "Extension" to the file itself in your 
system design phase.

John P. Carr CDP
EdgeTech 
5921 Acorn Ridge CT. Midlothian VA. 23112
Ph. 804-739-7689   Fax. 804-739-7950
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *