RE: opnqry Vs LF

["Tyler, Matt" <mattt@xxxxxxxxxxxxxx>]

Matt,
        The size should not dictate the need for an index (LF) but the
frequency the index will be used should.  If the only place the index is
used is in this program and only when OPNQRYF is used then why waste system
resources maintaining an index that big?  OPNQRYF can be modified to
optimize the building of the temporary index.

Thank you,
Matt Tyler
Mattt@wincofoods.com

-----Original Message-----
From: Haas, Matt [mailto:Matt.Haas@thomsonlearning.com]
Sent: Friday, October 11, 2002 12:52
To: rpg400-l@midrange.com
Subject: RE: opnqry Vs LF

<snip>
Since, the program is only run once a month there is no great need to create
a logical file.
<snip>

Unless it's a huge file that can take hours to index.

Matt
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.