Re: RPG CGI application

If the SQL is run from one server, you may look at the Dynamic Expanded SQL
API (QSQPRCED).

This lets you prepare an SQL statement in advance and store the details in
an SQL Package. Those SQL Packages cannot be distributed, they are local.
Each SQL statement has a statement name (max 18 characters, IIRC) and is
called by that name.
You have to set up and use SQLDA to pass parameters to the statement
(parameter markers).
Records are also fetched via the SQLDA.

Just a thought.

With regards,
Carel Teijgeler

*********** REPLY SEPARATOR ***********

On 21-10-2008 at 13:32 Vern Hamberg wrote:

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