RE: SQLRPGLE - Load-Up question...

[dmosley@xxxxxxxxxx]

No, these are pretty simple srvpgms.   I may have one file in the f-spec,
and that one doesn't have a USROPN, becuase I need it open everytime.

Thanks, though.

David L. Mosley, Jr.
Systems Analyst
2000 CentreGreen Way
Suite 250
Cary, NC 27513



                    Scott
                    Mildenberger             To:     "'rpg400-l@midrange.com'" 
<rpg400-l@midrange.com>
                    <Smildenber@Washc        cc:
                    orp.com>                 Subject:     RE: SQLRPGLE - 
Load-Up question...
                    Sent by:
                    rpg400-l-admin@mi
                    drange.com


                    05/22/02 01:27 PM
                    Please respond to
                    rpg400-l






David,

You mention service programs, do those service programs have f spec's also
or is all access through SQL?  If there are a large number of files on f
spec's and they are not coded USROPN then they are all opened when the
service program is activated.  We have had a couple of instances where the
delay due to this was very noticable.  We have gone to coding all files in
service programs as USROPN and then only opening them when they are needed.
If these service programs access procedures from other service programs
then
they are being activated at start up also.

Scott Mildenberger

> -----Original Message-----
> From: dmosley@dancik.com [mailto:dmosley@dancik.com]
> Sent: Wednesday, May 22, 2002 10:36 AM
> To: rpg400-l@midrange.com
> Subject: SQLRPGLE - Load-Up question...
>
>
>
> I've created several SQLRPGLE service programs that are used
> for display
> files into subfiles. No, problem.
> However, the very first time of entering the program, there
> is a delay of
> several seconds more than a normal RPGLE program would have.
> I'm guessing that it is the SQL-stuff loading up. (Not sure
> of the proper
> terminology, don't kill me).
>
> Is there a way to shrink this time down.  After the first
> entry, is ok.
> SQL activation groups are all still active, and the program
> flies right
> into action.  It's just that first time, that sucks.   Also,
> these same
> service programs are used for loading up HTML, and the
> load-up time on that
> is even longer.
> It's hard to sell the idea of SQLRPGLE objects, when right
> off the bat, the
> user experiences a delay.   First impressions are hard to get past..
>
> thanks
> dav
>
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/rpg400-l
or email: RPG400-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.