Re: Outcome of my research on OCP.

Andy Hassall wrote:

> I've had a go with the demos on my (somewhat resource constrained...) dev
> machine running 10.1.0.4, and I'm consistently seeing the "old_way" procedure
> running faster than "bulk_test".

I routinely get a 20-25% improvement between them. But to really see the value in bulk collection, without attending one of my lectures, try one of the examples with "LIMIT p_array_size;" in it. It is by changing the array size, jsut as with SQL*Plus, that you really see the difference.

Thanks.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)