RE: RPG CGI application

Thanks all.

We are looking at more memory at the moment. I'm not sure if this will
also improve the SQL issue. If not I will have to revisit it.

Rob Ferguson
Sr. Developer/Analyst
Profound Logic Software, Inc.




-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Dan Kimmel
Sent: Wednesday, October 22, 2008 10:10 AM
To: Midrange Systems Technical Discussion
Subject: RE: RPG CGI application

The answer is probably going to be to allocate more memory to the
subsystem where your CGI programs are running and the simplest way to do
that is probably to buy more memory. From your description it is very
likely your HTTP server and CGI jobs are being swapped out and that SQL
is having to wait for other jobs to be swapped out in order to load up
for the first time in your CGI jobs.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Vern Hamberg
Sent: Tuesday, October 21, 2008 1:33 PM
To: Midrange Systems Technical Discussion
Subject: Re: RPG CGI application

We see this with some customers - I have so far attributed it to paging
out of memory when a program has not been used in a while. Loading SQL
is always a fairly intensive process.

But if someone has a solution, we have customers that would love you!

profound wrote:

I have a number of RGPLE CGI programs running in persistent mode,
some using dynamic SQL. I have noticed 2 problems



1. When a program containing SQL is first called, it takes a
significant time to run (sometimes up to 14 seconds). Any subsequent
call to the same program will run normally in less than a second.



2. When running non-SQL programs, and the user stops using the system

for approx 30 minutes, the first program takes a very long time to run

when the user resumes using the system again ( sometime up to 20
seconds).







Any suggestions?



Thanks,



Rob Ferguson
Sr. Developer/Analyst
Profound Logic Software, Inc.
Phone: 937-439-7925
Toll-Free: 877-224-7768
Fax: 603-849-7757
rferguson@xxxxxxxxxxxxxxxxx <mailto:rferguson@xxxxxxxxxxxxxxxxx>
www.profoundlogic.com <http://www.profoundlogic.com>



Modernization Made Easy

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