Re: slow response time for first, and only first time program is run.

[Alan Campin <alan0307d@xxxxxxxxx>]

SQL? First run of an SQL program requires that you run the optimizer.

On Fri, Aug 14, 2009 at 10:06 AM, Booth Martin <booth@xxxxxxxxxxxx> wrote:

> This doesn't make sense to me.
>
> Here is what we're doing:  We are running a program with this H-spec:
>     H option(*nodebugio) dftactgrp(*no) actgrp(*new)
>
> The first session runs for about 4 minutes before displaying data.
> Every session after that, whether from the same user or another user,
> displays the same  data in under 6 seconds.   Even if all instances of
> the program are ended, restarting a session is under 6 seconds.
>
> 30 to 40 spool files are generated by the process.
>
> What could possibly be different between the first time and the
> subsequent times?
>
>
>
>
>
>
>
> --
> ---------------------------------
> Booth Martin
> http://www.Martinvt.com
> ---------------------------------
>
> --
> 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.