Tuning ProC Cursors...

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 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 Received on Fri May 01 1998 - 13:12:38 CDT