SQLRPGLE - Load-Up question...

[dmosley@xxxxxxxxxx]

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


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