Re: Triggers

It all depends on how you implement the triggers. For example our triggers
look to see if they are running in batch, if so then the trigger does not
set on the LR indicator and performance is actually very nice. We do shut
down our triggers for interactive jobs though...

______________________________________________
Eric N. Wilson
President
Doulos Software & Computer Services
2913 N Alder St.
Tacoma WA 98407


----- Original Message -----
From: "Bob Entwistle" <bentwist@famousfootwear.com>
To: <MIDRANGE-L@midrange.com>
Sent: Thursday, February 17, 2000 1:31 PM
Subject: 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
> +---
>

+---
| 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
+---