RE: SQLRPGLE - Load-Up question...

["Smith, Mike" <Mike_Smith@xxxxxxxxxxxxxxxx>]

David
Do you have an 'Optimize for x rows' on your select statement?

-----Original Message-----
From: dmosley@dancik.com [mailto:dmosley@dancik.com]
Sent: Wednesday, May 22, 2002 12:36 PM
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


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

_______________________________________________
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.