Re: FMTDTA Vs OPNQRYF..

[DAsmussen@xxxxxxx]

Charlie,

In a message dated 97-05-31 15:48:12 EDT, you write:

> I agree FMTDAT used to be MUCH faster than OPNQRYF on large files.  As I
>  recall, on A S/38 our rule of thumb was 20,000 or more record use FMTDTA.
 I
>  do not think that FMTDTA is that much faster than OPNQRYF on the AS/400. I
>  have not run any structured performance comparisons recently.  Has anyone 
> else?

Good question.  This was another of those "I almost didn't answer" questions,
because I hadn't used FMTDTA in so long.  As I understand it, OPNQRYF uses a
subset of SQL commands.  Since the advent of V3, SQL performance is GREATLY
increased (until you reach 200K records or so) on the AS/400.  I would
certainly be interested in any RECENT performance comparisons as well...

Thanks!

Dean Asmussen
Enterprise Systems Consulting, Inc.
Fuquay-Varina, NC  USA
E-Mail:  DAsmussen@AOL.COM

"Visualize whirled peas" -- Anonymous
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *