×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Unfortunately no.
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Bryce Martin
Sent: Tuesday, January 18, 2011 12:25 PM
To: RPG programming on the IBM i / System i
Subject: Re: Subfile initial load very slow
Is there an SQL statement used to read the data?
Thanks
Bryce Martin
Programmer/Analyst I
570-546-4777
Andy Devries <andyd@xxxxxxx>
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
01/18/2011 02: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
