Re: When is %EOF not an %EOF -- RPG400-L

× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.

On Tuesday, September 30, 2003, at 12:19 AM, DeLong, Eric wrote:

I find it very interesting that by simply changing a reade to a read and then testing the keys manually can improve performance so dramatically.

The secret is blocking. Fixing the I/O is the single best thing you can do to fix performance problems (presuming there are no physical constraints like insufficient main storage, or a gutless processor).

As an example I changed a conversion process at a previous employer to reorganise the work files into keyed sequential order, used a large blocking factor, and dropped the run time from 3 days to 12 hours.

I wouldn't suggest that you religiously use "READ and test" in place of READE especially if the values you want are widely separated (i.e., a sparse key) but whenever you are processing large amounts of data sequentially by key a good old-fashioned sort followed by sequential reads can significantly improve the run time.

Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@xxxxxxxxxxxxxxxxx   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------

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.