Re: Tuning ProC Cursors...

I have tried using host array to store a chunk of the records from each cursors. The initial retrieval was pretty good. But after a while, like couple of hundred of records were retrieved from each cursors, the performance collapse. The retrieval time were not linear anymore.

I am suspecting that there were thashing or heavy swapping. Something like the cursors has used up all the resources.

Then I tried setting the hold_cusror = YES and release_cursor = NO but it didn't help.

Thanks in advance again for any help.

PS. the records in each of the 4 tables contains an average of several hundred thousand of records.

> On Tue, 05 May 1998 14:25:56 +0100, Keith Jamieson <pdkj02_at_email.mot.com>
> respond :
>Try retrieving the data from each cursor into an array. Then walk through
>the arrays.
>

>
>
>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
>
Received on Fri May 08 1998 - 01:48:51 CDT