Not what I meant Sharon. Just trying to state that I've never seen this,
and I have much less experience than you do, that is for sure. Please
don't take it as a knock, I was just saying I've done similar things to
what the OP described and have never run into this, that's all.
I have read all subsequent posts in this thread but not before I sent that
message. I don't mean to offend.
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
"Wintermute, Sharon" <Sharon.Wintermute@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/19/2011 09:17 AM
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
Back on the AS/400 (yes, I am older...), I have seen this exact problem.
Other responses were asking about database issues so I was going
"outside the box" and trying other options. I HAVE used subfiles that
were significantly larger than the subfile page. I HAVE seen this
problem when trying to load a huge subfile that has a lot of the fields
per subfile record. I HAVE seen memory allocation in the pools cause
this issue. My personal experience instigated the "outside the box"
suggestion.
If you saw subsequent posts, since the OP did eliminate this possible
issue, I did ask about I/O.
Don't knock someone else's troubleshooting ideas. Use them as a learning
experience.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryce Martin
Sent: Wednesday, January 19, 2011 8:06 AM
To: RPG programming on the IBM i / System i
Subject: RE: Subfile initial load very slow
Sharon,
It may be the problem, but my suspicion is elsewhere. I have NEVER had
a
SFLSIZ that was more than 1 more than the SFLPAG. And I have NEVER seen
this type of issue. My guess is more of a datebase IO issue, files
being
opened, program not in memory, etc etc. You might be right, but from my
personal experience, I don't think that's it.
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
"Wintermute, Sharon" <Sharon.Wintermute@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2011 05:12 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
Do you understand that by the system having to reallocate the subfile to
get it to 500 records from a definition (SFLSIZ) of 13, it is going to
take some time? That is 39 times it has to reallocate the subfile.
This is probably your problem.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Andy Devries
Sent: Tuesday, January 18, 2011 4:08 PM
To: RPG programming on the IBM i / System i
Subject: RE: Subfile initial load very slow
I hope this is what you are asking. When I looked at the job when it
completed (loading and displaying the subfile). I read 4 different data
base files to produce one subfile record. The actual subfile ends up
containing just over 500 records.
After the initial load, it is possible that the subfile could be
reloaded - the file is static enough that new records would not be
added.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Gary Thompson
Sent: Tuesday, January 18, 2011 1:43 PM
To: RPG programming on the IBM i / System i
Subject: RE: Subfile initial load very slow
More questions to focus on the reason the initial load seems so much
slower:
1) Do you know about how many records are read from the database
to load one subfile record?
2) After initial load, is the subfile reloaded, or are new
records
added to existing subfile records?
By tracking program i-o, you might find that performance is not changing
as much as the amout of program i-o is changing
In my experience, subfile i-o is relatively fast compared to database
i-o
Andy Devries <andyd@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2011 02:21 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 Paul - The program is a simple call from a CL - Displays the
subfile screen with input fields. Once <ENTER> is hit the subfile build
happens. It's the time between the build and redisplay that can be very
long. Not all 3000+ records are part of the subfile.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of paultherrien@xxxxxxxxxxxxxxxxxx
Sent: Tuesday, January 18, 2011 12:59 PM
To: 'RPG programming on the IBM i / System i'
Subject: RE: Subfile initial load very slow
Is there anything else occurring when the program initializes? It
doesn't
sound like a subfile issue exactly.
Since it only occurs when the program is first loaded it indicates that
there is some initialization going on which may or may not have anything
to
do with the subfile.
Paul Therrien
Andeco Software, LLC
932 Saint Johns Dr
Maryville, TN 37801
225-229-2491
paultherrien@xxxxxxxxxxxxxxxxxx
www.andecosoftware.com
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx
[mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Andy Devries
Sent: Tuesday, January 18, 2011 2:30 PM
To: rpg400-l@xxxxxxxxxxxx
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
