RE: Different processing times...why?

["Andy Nolen-Parkhouse" <aparkhouse@xxxxxxxxx>]

Ray,

Two thoughts come to mind:

The first is to use the SETOBJACC command (response already posted from
Vern).  If your subsystem has an appropriate amount of memory available,
you can load all relevant database files into memory prior to the
initiation of your program.  There is some time required to load the
files, but it would probably less than your RPG program.

The second would be to examine the use of blocking on your input.
Examine the use of the OVRDBF command, particularly the SEQONLY and
NBRRCDS parameters.  This will force the system to bring larger chunks
of data into memory in a single pass, eliminating a number of physical
disk accesses.  Check the warnings in the CL reference regarding
sequential processing.

Regards,
Andy Nolen-Parkhouse


> On Behalf Of Ray Nainy
> Subject: Re: Different processing times...why?
>
> Mike,
>
> LR is set on before the program gets terminated. So, the only possible
> reason I can see is the records being held in memory for a short
period of
> time.
> Is there any option to rerieve the records much faster when the RPG
> program
> is called for the first time?
> ***Pl. see the Original Message below***
>
> Ray