SFLSIZ greater than SFLPAG causes the iSeries to automatically expand the
file as subfile records are added, so the real
controlling factor is how the program that loads the subfile is
written.
One great resource is one of the books on MC Press if you are getting into
subfiles for the first time. If I remember, Subfile Magic or
something like that was a great tool for me.
Remember, a "page at a time" design requires the subfile program to keep
track of which records are currently
displayed and to load/reload the subfile as the user pages or
browses through the data, so there
is a fair amount of logic to do this.
Andy Devries <andyd@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2011 01:51 PM
Please respond to
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
To
RPG programming on the IBM i / System i <rpg400-l@xxxxxxxxxxxx>
cc
Subject
RE: Subfile initial load very slow
Thanks Gary - I've set up the SFLSIZ= 13 AND SFLPAG = 12. I thought this
would do a page at a time but display the next page (and keeping the
original) when you do a page down??
Maybe I should set the SFLSIZ to be 4000?
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Gary Thompson
Sent: Tuesday, January 18, 2011 12:10 PM
To: RPG programming on the IBM i / System i
Subject: Re: Subfile initial load very slow
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
