Re: Oracle direction on triggers

From: Noons <nsouto_at_optusnet.com.au.nospam>
Date: 25 Feb 2003 14:20:48 GMT
Message-ID: <Xns932EB2A3D254Tokenthis@210.49.20.254>

Following up on Ed Stevens, 26 Feb 2003:

>>

> Questions he has been unable to answer. Just the statement "our
> transaction has to wait for the trigger to do its work." Well, in an
> absolute sense, that is true, but he has been unable to quantify that
> wait, which leads me to belive that it is negligible.

That definitely sounds like he's going for "gospel" type stuff instead of facts.

>
> And as it turns out, the app that requested the trigger doesn't
> *really* need real-time updates to their table, so we are going to
> investigate a batch procedure.
>

Bingo. You got it in one. I've yet to see one of these "send it to DB2" interfaces that really needs that sort of real-time response. The batch stuff is a much better way of achieving this.

-- 
Cheers
Nuno Souto
nsouto_at_optusnet.com.au.nospam

Received on Tue Feb 25 2003 - 08:20:48 CST