Re: bulk binds with AQ

never would be in system.......in user tablespace

update takes about 2 seconds on its own.....

nsouto_at_optushome.com.au.nospam (Nuno Souto) wrote in message news:<3b8cccdc.8756819_at_news>...
> On 28 Aug 2001 15:29:01 -0700, sgelberg_at_optonline.net (Seth) wrote:
>
>
> By itself, how long does this take? Assuming you are not doing the
> send message?:
>
> > UPDATE IOI
> > SET status = 'E'
> > WHERE (status = 'A' OR status = 'V' OR status = 'M') and
> >(expire_time <=
> >v_curTime)
> > RETURNING ioi_id, symbol, side, ord_type, clordid, order_qty,
> >sender_comp_id, sender_sub_id,
> > on_behalf_comp_id, on_behalf_sub_id, echo_text
> > BULK COLLECT INTO v_ioiTab, v_symbolTab, v_sideTab, v_ordTypeTab,
> >v_clordidTab, v_orderQtyTab, v_sciTab, v_ssiTab,
> > v_obciTab, v_obsiTab, v_echoTextTab;
>
>
> Also:
>
> > hsp_utilities.SendFixMsg(hsp_utilities.v_fixQueOut, v_fixRec,
> >'8');
>
> what type of queue is this? Multi-recipient (publish-subscribe)? Or
> simple? Is your queue table in tablespace SYSTEM?
>
>
> Cheers
> Nuno Souto
> nsouto_at_optushome.com.au.nospam
Received on Wed Aug 29 2001 - 20:12:58 CDT