Re: Different processing times...why?

Paul,

Both the files are properly keyed and access paths exist even before the
file is opened(logical).

Ray

>From: PaulMmn <PaulMmn@ix.netcom.com>
>Reply-To: midrange-l@midrange.com
>To: midrange-l@midrange.com
>Subject: Re: Different processing times...why?
>Date: Sat, 13 Jul 2002 10:07:48 -0400
>
>Ray--
>
>Is the file you're reading set to rebuild access path only when the
>file is opened?  That would account for the delay opening the file
>for the first time.
>
>I'm not sure if the system would keep the access path around for 20
>minutes as you've found, but if it's the same session, it might.
>
>--Paul E Musselman
>PaulMmn@ix.netcom.nospam.com
>
>
>
>
>>We have an RPG program that reads approximately 4500 records from
>>file A and reads matching records in file B using account number.
>>File B has a total of 2 million records.
>>It takes about 60 to 70 seconds to complete the processing when the
>>program
>>is called for the first time. But it takes only 3 to 4 seconds to complete
>>the processing, when the program is called again 2nd or 3rd or 4th or
>>5th...time. Processing time is 60 to 70 seconds only for the first call.
>>This happens again if the session is idle for 20 minutes or more. We
>>couldn't find out why is this processing time more only for the first call
>>to the RPG program. We verified and found that this problem exist
>>anytime, irrespective of the peak/non-peak hours of the day.
>>
>>Any help is greatly appreciated.
>>
>>Ray
>_______________________________________________
>This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
>To post a message email: MIDRANGE-L@midrange.com
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
>or email: MIDRANGE-L-request@midrange.com
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/midrange-l.




_________________________________________________________________
Send and receive Hotmail on your mobile device: http://mobile.msn.com