Re: Looking for activation group opinions

[Alan Cassidy <cfuture@xxxxxxxxxxx>]

Thanks, Code 1109.

Yes, the program had been loading the entire subfile with selected 
records before I changed to use multi-row fetch. At that time I changed 
to inputting one subfile page at a time.

It's a bunch of programs that use the same main driver file, reloaded 
with different selections for each program, so over the long term i'm 
thinking of having them access one separate program or service procedure 
as a kind of I/O server that sticks around between them.

Thanks for the brainstorming everybody.

--Alan


On 3/5/2022 12:03 PM, Code 1109 via RPG400-L wrote:
> Assuming it loads a subfile, it might be loading file(s) completely instead of by page or range, and if the loaded file(s) are high volume it could be part of the cause, another could be that each time it's called it open/close files instead of user cntrolled open/close, it can also be that files(s) have not been reorganized in a long time, it could be that recs get locked, etc etc.
> I hope you find a good solution to your need