Re: Subfile initial load very slow

[Booth Martin <booth@xxxxxxxxxxxx>]

A couple of thoughts:
------------------------------------------------
SFLSIZ the size of the file:
     A                            SFLSIZ(&NBRREC)
     A  91                        SFLEND(*SCRBAR *MORE)

...
     A            NBRREC         5S 0P

     C   FillSubfile  BegSR
  ...
     C                Exsr      WriteLineSR
     C                Write     SFLA
     C      Eval      RRN = RRN + 1
  ....
     C      Eval      NBRREC = RRN
     C                EndSR
-----------------------------------------------------
Here is my usual error that causes this:  I load the subfile two or 
three times at the beginning.  (That is not intentional!)  When I fix my 
flow, and just do it once, performance improves.
------------------------------------------------------------------
Just for fun, I wonder how the program itself loads.  Is it really the 
subfile causing the delays, or is there other stuff happening with job 
startup?  File sorting, arrays being loaded, various overrides in the 
CL?  I wonder if you were to place a dsply line in as the very last 
c-spec in the *INZSR subroutine, how long it would be before that popped 
up?
------------------------------------------------------
Add the scroll bar keyword *SCRBAR (you need 3 empty columns on the 
right side of the panel).  It is useful with a 3200 record subfile.
---------------------------------------------------------------------
My experiences are that a 2500-record load-all subfile is pushing the 
limits of being usable by a user.  The subfile pagekeys are just too 
slow, and one tick of the scroll bar can jump 3 or 4 panels.




On 1/18/2011 1:30 PM, Andy Devries wrote:
> 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