Re: More Efficient Processing ideas...

[Marco Facchinetti <facchinetti@xxxxxxxxx>]

If the problem is speed sql/opnqryf are the choice, both of
them are n times faster than RPG, especially if the record
is long. Of course you pay a little as overall performance
but, as others already pointed out, can be minimized using
index built on the most common used fields.

HTH
Marco
--- fkany@xxxxxxxxxxxxxxxxxx wrote:
> 
> Currently my program below reads every single record in
> the file to see if it matches certain criteria before
> processing a record.  There are millions
> of records in this file and it takes the program forever
> to complete.  The criteria for checking each record
> depends on whatever the user enters.  So
> far there's
> about 5 or 6 criteria it must meet.  1 happens to be a
> date range, another is customer number, billing numbers,
> etc...  I don't want to create any
> logicals since
> the criteria can change, but I'd like to have the
> subprocedure read a file that's already sorted.


__________________________________
Do you Yahoo!?
Yahoo! SiteBuilder - Free, easy-to-use web site design software
http://sitebuilder.yahoo.com