Re: FIRST JAVA SELECT VERY SLOW

We have the same problem.
But if we start the cgi-program two times the behaviour is the same. It does not seem to be a cache problem.

Regards
Frank Sauerbier

A b a M e d i C u s

Weinbergweg 23                D-06120 Halle
Telefon: +49(345)5583744      Fax:+49(345)5583751
Email: abamedicus_at_gmx.net     Compuserve: 100417,2734

ronb_at_digitalmarket.com wrote:

> This is most likely because the first select statement in your cgi program
> (or any SQL based program/script) is having to go out to disk to get the data
> requested by the first select. The next select statement in the program will
> probably have many of the needed data blocks already in the SGA that were
> placed there by the first statement so it does not have to go out to the disk
> as much. In other words, your second and following select statements will
> have a higher cache hit ratio than the first statement.
>
> Regards
>
> Ron Bogdanoff
> Sr. Software Engineer
> Digital Market Inc.
Received on Sun Jan 10 1999 - 11:21:15 CST