Re: Subfile initial load very slow

[Alan Shore <AlanShore@xxxxxxxx>]

Hi Andy
One thing comes to mind
by initial load, are you talking about the first for the day, or the first
for each user
Does the program use a logical and is that logical being built for the
first time being used that day

Alan Shore
Programmer/Analyst, Direct Response
E:AShore@xxxxxxxx
P:(631) 200-5019
C:(631) 880-8640
"If you're going through Hell, keep going" - Winston Churchill


                                                                       
             Andy Devries                                              
             <andyd@xxxxxxx>                                           
             Sent by:                                                   To
             rpg400-l-bounces@         "rpg400-l@xxxxxxxxxxxx"         
             midrange.com              <rpg400-l@xxxxxxxxxxxx>         
                                                                        cc
                                                                       
             01/18/2011 03:05                                      Subject
             PM                        Subfile initial load very slow  
                                                                       
                                                                       
             Please respond to                                         
              RPG programming                                          
              on the IBM i /                                           
                 System i                                              
             <rpg400-l@midrang                                         
                  e.com>                                               
                                                                       
                                                                       




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

--
This is the RPG programming on the IBM i / System i (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.