Re: Triggers

We are a Lansa shop and tried using triggers a few years ago.  We found that
high volume applications could run 10-20 times longer when using triggers.  This
situation may have improved since then and it's hard for me to know if this was
due to Lansa's implementation or the AS400's implementation of triggers.  In any
case, there will be more overhead and if you've got screens or low volume apps,
there shouldn't be a performance problem.

Bob Entwistle
Famous Footwear  bentwist@famousfootwear.com





"Graziano, Marie" <mgraziano@badgermeter.com> on 02/17/2000 09:21:31 AM

Please respond to MIDRANGE-L@midrange.com

To:   "'Midrange'" <MIDRANGE-L@midrange.com>
cc:    (bcc: Bob Entwistle/HQ/Corporate)

Subject:  Triggers



Does anyone have any gotcha's on using triggers?  We have a product being
installed and they are using data ques and triggers.  We are not really
educated in triggers.

mgraziano@badgermeter.com <mailto:mgraziano@badgermeter.com>


Marie Graziano

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---









+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---