Re: bulk binds with AQ

On 29 Aug 2001 18:12:58 -0700, sgelberg_at_optonline.net (Seth) wrote:

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

fine.

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

OK, this is important. Did you measure these 2 seconds on a standalone UPDATE or *the specific one* you're using here, *including* the BULK COLLECT and the RETURNING?

I'm thinking along these lines:
If you have the wrong type of arrays to keep the RETURNING/BULK COLLECT data, it may be where the time is being spent.

Can you replace the multiple arrays, one for each column, with a single array of a RECORD type that has all the columns inside it? That should take less time to fill up.

Also, as I said: is the queue simple or multi-recipient? The latter is much slower.

Cheers
Nuno Souto
nsouto_at_optushome.com.au.nospam Received on Thu Aug 30 2001 - 05:37:59 CDT