Is there an SQL statement used to read the data?
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
Andy Devries <andyd@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2011 02:30 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
To
"rpg400-l@xxxxxxxxxxxx" <rpg400-l@xxxxxxxxxxxx>
cc
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
midrange.com
