One possible approach is to re-write as a "page (or two) at a time"
subfile
This requires your program to keep track of the user's current position in
the data - not trivial the first time you develop this style -
but your response time should be very consistent regardless of the
amount of data because only 15-30 subfile records
are loaded at any time.
My guess is the page at a time approach would be a major re-write, so
maybe more detail about how the data is loaded and
how many sub file records are populated would expose another
issue. After all, populating 3000 subfile records could
require a bunch of I-O, depending on your database.
Andy Devries <andyd@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2011 12: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
