a regular update executes in 1-2 seconds....
Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<u66b79vqy.fsf_at_verizon.net>...
> On 28 Aug 2001, sgelberg_at_optonline.net wrote:
>
> > I have this proc that takes 12 seconds to update 1600 rows and
> > enque 1600 messages(sendmsg is my enque procedure that calls
> > oracles dbms_enque).
> >
> > I'm wondering if anyone has any suggestions for improving the
> > performance of this proc
>
> Forgetting about updating, what's the performance of this query
> like?
>
> SELECT ioi_id, symbol, side, ord_type, clordid, order_qty,
> sender_comp_id sci, sender_sub_id ssi,
> on_behalf_comp_id obci, on_behalf_sub_id obsi, echo_text
> FROM ioi
> WHERE (status = 'A' OR status = 'V' OR status = 'M') and
> (expire_time <= v_curTime);
Received on Wed Aug 29 2001 - 10:49:33 CDT
