RE: a need for speed

I'm probably late, but SQL or Query would do this without too much work.
In RPG sequential reads--no random I/O--would go pretty fast.  If you
tweak the blocking it would go even faster than the default block size.
If the file is ordered by area code, prefix, and suffix it would be easy
to code and fast.

We do mailing list processing in house and routinely blow through files
with five to ten million records in a matter of minutes. It all involves
read from one file, do something according to criteria known at run time
and write to a new one. 

<><><>-----Original Message-----
<><><>From: rpg400-l-bounces@xxxxxxxxxxxx
<><><>[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
<><><>Sent: Thursday, August 18, 2005 2:34 PM
<><><>To: RPG programming on the AS400 / iSeries
<><><>Subject: a need for speed
<><><>
<><><>Can below be done without having to read thru each record
<><><>in detail file(Telephone Master)?
<><><>
<><><>I need to summarize a big telephone master file (22M+)
<><><>into ranges.  I'm attempting to use read, reap, setll to
<><><>avoid the need to read each phone number record to create
<><><>this summary file.  However, no luck so far.
<><><>
<><><>The detail file looks like below:
<><><>AreaCode    Prefix    Suffix    Terminal
<><><> 601         123       0001      JSN
<><><> 601         123       0002      JSN
<><><> 601         123       0003      JSN
<><><> 601         123       0004      JSN
<><><> 601         123       0009      BTD
<><><> 601         123       0010      BTD
<><><> 601         123       0044      BTD
<><><> 601         123       0091      JSN
<><><> 601         123       0092      JSN
<><><> .
<><><> .
<><><> .
<><><>
<><><>
<><><>The summary file is by AreaCode, Prefix, Terminal, From
<><><>Suffix, to Suffix.  Using above data, the result should
<><><>be as follow:
<><><>AreaCode    Prefix    Terminal    From Suffix    to Suffix
<><><>601          123        JSN         0001           0004
<><><>601          123        BTD         0009           0044
<><><>601          123        JSN         0091           0092
<><><>
<><><>
<><><>--
<><><>This is the RPG programming on the AS400 / iSeries
<><><>(RPG400-L) mailing list To post a message email:
<><><>RPG400-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
<><><>change list options,
<><><>visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
<><><>or email: RPG400-L-request@xxxxxxxxxxxx
<><><>Before posting, please take a moment to review the
<><><>archives at http://archive.midrange.com/rpg400-l.
<><><>
<><><>

*****************************
NOTICE:
All e-mail sent to or from this e-mail address will be received or otherwise 
recorded by
The Sharper Image corporate e-mail system and is subject to archival, 
monitoring,
and review by and/or disclosure to Sharper Image security and other management.
This message is intended only for the use of the addressee and may contain 
information
that is privileged and confidential.

The contents of this message may contain personal views which are not the views 
of The Sharper Image.
If you are not the intended recipient, dissemination of this communication is 
prohibited.
*****************************