Re: READE vs. READPE performance

[Ben_Pforsich@xxxxxxxxxxxx]

That makes sense.  I've always been a bit lazy and relied on READE and
READPE for read loops and just checking for %eof.  I think I will use READP
on the ascending-key file and when the company or route changes, then just
LEAVE the loop before %eof.  Thanks!

Ben




                                                                           
             Tony Carolla                                                  
             <carolla@xxxxxxxx                                             
             m>                                                         To 
             Sent by:                  RPG programming on the AS400 /      
             rpg400-l-bounces@         iSeries <rpg400-l@xxxxxxxxxxxx>     
             midrange.com                                               cc 
                                                                           
                                                                   Subject 
             12/09/2005 02:21          Re: READE vs. READPE performance    
             PM                                                            
                                                                           
                                                                           
             Please respond to                                             
              RPG programming                                              
              on the AS400 /                                               
                  iSeries                                                  
             <rpg400-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




I have used both, but not for multiple simultaneous reads.  For the
performance issue, it would be best to use READ on the descending-key file,
or READP on the ascending key file, and crank up the block size using
OVRDBF
FILE(LOGICAL1) SEQONLY(*YES XXXX), where XXXX is the max number of records
that will fit in 128k.

Basically, SetLL and then READ or READP in a loop, and check key values
each
iteration through.

On 12/9/05, Ben_Pforsich@xxxxxxxxxxxx <Ben_Pforsich@xxxxxxxxxxxx> wrote:
>
>
> Generally speaking, has anyone tried or know for a fact which of the
> following scenarios result in better performance (faster I/O?)?...
> 1.  READE on logical with a descending key  (ex:  READE (Company : Route
:
> Date) LOGICAL1 where Date is keyed descending)
> 2.  READPE on logical with an ascending key  (ex: READPE (Company : Route
> :
> Date) LOGICAL2 where Date is keyed ascending).
>
> I want to read records in a history transaction file keyed with a date
> field starting with the most recent and going backward.  I'm trying to
> decide whether I should build a new logical over a fairly large physical,
> or use an existing logical and use READPE instead of READE.  I will be
> likely reading potentially 10,000 to 50,000 records in one pass and
> performance is an issue.
>
> Let me know if you need more information, but I was hoping for a quick
and
> dirty response.
>
> Thanks!
>
> Ben Pforsich
> Programmer Analyst
> Bob Evans Farms, Inc.
> I/S Department
> Columbus, Ohio
> Ben_Pforsich@xxxxxxxxxxxx
>
> --
> 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.
>
>


--
"Enter any 11-digit prime number to continue..."
"In Hebrew SQL, how do you use right() and left()?..." - Random Thought
"If all you have is a hammer, all your problems begin to look like nails"
--
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.