RE: Performance issue: open/read PF vs. open/read SRCPF

Bruce,

This question is an excellent candidate for an engineering approach to the
problem, i.e. try it and see.  The collective sense of the list is that
you'll see no performance issues, but perhaps you could actually model each
scenario, benchmark them and report the results back.  Run each model 1000
times or so to make the statistics more valid.  Be sure to do a CLRPOOL for
each run to be sure that subsequent runs are not using cached data.  Who
knows?  Perhaps the collective wisdom needs to be re-evaluated?

Buck Calabro
Aptis; Albany, NY

> -----Original Message-----
> From: Bruce Jin 
> Sent: Thursday, January 27, 2000 2:35 PM
> To:   RPG400-L@midrange.com
> Subject:      Performance issue: open/read PF vs open/read SRCPF
> 
>  I wonder how much difference there is (in terms of performance) when I
> use
> a physical file versus a source physical file. Assume I do OVRDBF, OPEN,
> READ, CLOSE in RPG. The record lengths for both PF and SRCPF are the same.
> The PF has only 1 or 2 fields in it. Both PF and SRCPF have 500 records.
> 
+---
| 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
+---