Re: Subfile initial load very slow

["Raul A. Jager W." <raul@xxxxxxxxxx>]

Check the parameter "MAINT" (mantenimiento de via de acceso) at my
office, set it to *IMMED.  If it is *DLY or *REBLD it will allow faste
updates to the base files, but it will cause to be slow when reading.

Andy Devries wrote:
> Thanks Alan - I've considered this.  There are 2 logicals - either by name or contract# - which ever is selected.  I thought it might be only the first time that day, but seems to happen on and off during the day.  
>
> -----Original Message-----
> From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Alan Shore
> Sent: Tuesday, January 18, 2011 12:09 PM
> To: RPG programming on the IBM i / System i
> Cc: rpg400-l@xxxxxxxxxxxx; rpg400-l-bounces@xxxxxxxxxxxx
> Subject: Re: Subfile initial load very slow
>
>
> 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.