Re: Tuning ProC Cursors...

Willy Chua wrote:

> On Fri, 01 May 1998 18:12:38 GMT, willy_at_dfi.com (Willy Chua) wrote:
>
> >Hi All,
> >
> >I have opened mutiple cursors and have to walk thru them at a certain
> >sequence. Unfortunately when I do these, the performance has
> >slowed down significantly.
> >I tried pinning( hold_cursor = yes and release cursor = no) and it
> >still does improves not the performance.
> >
> >If each cursor are opened and timed individually. It goes thru each
> >record pretty fast. But given the above scenario, the performance
> >goes down big time.
> >
> >Thanks in advance for your help,
> >
> >willy_at_dfi.com

Try retrieving the data from each cursor into an array. Then walk through the arrays. Received on Tue May 05 1998 - 08:25:56 CDT