RE: Efficient Code

["Reeve" <news@xxxxxxxxxx>]

SQL, and watch the optimizer results, and use the Operations Navigator to
analyze usage patterns.

I suggest examining the 51 logicals and get rid of the ones seldom used in
batch.  SQL or OPNQRYF might provide acceptable performance in selecting the
records you want.  Then go consider the likely ways a user would select/view
data, and make sure you have access paths built over those columns.  If you
STRDBG and run SQL or OPNQRFY, you'll see what access path was selected and
why; this can point you in the right direction.  

-rf   

> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
> On Behalf Of Chris_Bougher@xxxxxxxxxxxxx
> Sent: Tuesday, February 17, 2004 3:54 PM
> To: rpg400-l@xxxxxxxxxxxx
> Subject: Efficient Code
> 
> What would be the most efficient way to get records from a large file
where
> the user can enter selection criteria for as many as 16 fields. i.e.
> 
> Key1 is required
> Key2 is required
> Key3 is required
> 
> Field1 is optional
> Field2 is optional
> Field3 is optional
> Field4 is optional
> Field5 is optional
> Field6 is optional
> Field7 is optional
> Field8 is optional
> Field9 is optional
> Field10 is optional
> Field11 is optional
> Field12 is optional
> Field13 is optional
> 
> The file currently has over 9 million records and growing.
> 
> The file has a record length of almost 300 bytes.
> 
> The file currently has 51 logicals but none have the keys I need in the
> right sequence.
> 
> The screen requires that values be entered for the key values but the
> others may  or may not have values entered.
> 
> I am not sure if SQL would be the best or making a few logicals over the
> file with only the keys and checking the record against the entered data
> would be better.
> 
> Any opinions?
> 
> Thanks in Advance.
> Chris Bougher
> 
> 
> 
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.