RE: Subfile initial load very slow

Thanks Paul - The program is a simple call from a CL - Displays the subfile screen with input fields. Once <ENTER> is hit the subfile build happens. It's the time between the build and redisplay that can be very long. Not all 3000+ records are part of the subfile.

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of paultherrien@xxxxxxxxxxxxxxxxxx
Sent: Tuesday, January 18, 2011 12:59 PM
To: 'RPG programming on the IBM i / System i'
Subject: RE: Subfile initial load very slow

Is there anything else occurring when the program initializes? It doesn't
sound like a subfile issue exactly.
Since it only occurs when the program is first loaded it indicates that
there is some initialization going on which may or may not have anything to
do with the subfile.

Paul Therrien
Andeco Software, LLC
932 Saint Johns Dr
Maryville, TN 37801
225-229-2491
paultherrien@xxxxxxxxxxxxxxxxxx
www.andecosoftware.com

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Andy Devries
Sent: Tuesday, January 18, 2011 2:30 PM
To: rpg400-l@xxxxxxxxxxxx
Subject: Subfile initial load very slow

I've been scratching my head about this one for some time. This is an RPG400
program. I have a subfile that is loaded from a file that only contains
3200 records. The initial load takes a long time (over a minute). In
subsequent calls to the same program, it responds much better (2-3 seconds).
I've gone into debug - doesn't seem to hang at any location. I've watched
it process (WRKACTJOB) and it seems to do the same process. I have looked
at locked records - doesn't seem to be a problem. Can anyone suggest other
techniques for debugging this problem. As you can imagine, the users don't
like the long delay.
Andy