Re: Expensive op codes

[boothm@xxxxxxxxxxxxxxxxx]

Firstly, thanks for the info.  It is interesting, and not at all the 
results I would have predicted excepting the results obtained when you 
removed the K.

What I am still curious about though is: What would have happened if you 
had used the cycle to process the same records?  No READ, no READE, just 
InputPrimary on the keyed file.




Please respond to RPG400-L@midrange.com
Sent by:        owner-rpg400-l@midrange.com
To:     RPG400-L@midrange.com
cc: 

Subject:        Re: Expensive op codes

Vanja Jovic wrote:


Both test runs used OVRDBF FILE(ECLL02) SEQONLY(*YES 341)
Both test runs read the entire file by key.  Program 1 used READE, program 
2 used
READ and compare.

Program 1 elapsed time was 33 minutes 38 seconds.
Program 2 elapsed time was 12 minutes 38 seconds.

I think I will be using the READ/Compare model versus the READE model 
whenever
possible when I need to read by key.

By the way, reading the non keyed physical file with the same OVRDBF only 
took 1
minute 22 seconds.


+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---