×
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.
Scott:
No, but the performance is terrible. On the client side the RGPLE program
does an SQL call to a stored procedure on the server. The server side
stored procedure then calls a few RPG program along the way. It just seems
to run VERY slow.
cjg
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Thursday, February 19, 2009 6:48 PM
To: Midrange Systems Technical Discussion
Subject: Re: Stored procedure that calls another program
Hi Carl,
Are you saying that an RPG CALL is running slower than invoking the same
program via an SQL CALL? That doesn't make much sense to me.
Carl Galgano wrote:
All, thanks for the replies.
Alan, you are correct, my stored proc is an RPGLE program, and it
calls other RPGLE programs directly using a CALL. I am not turning on
LR (using a return), but the performance seems to be slow.
The SQL itself is VERY fast.
cjg
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at
http://archive.midrange.com/midrange-l.
No virus found in this incoming message.
Checked by AVG - www.avg.com
Version: 8.0.237 / Virus Database: 270.11.2/1964 - Release Date: 02/21/09
15:36:00
midrange.com
