|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.