Re: RPG CGI application

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

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