Re: FIRST JAVA SELECT VERY SLOW

From: <ronb_at_digitalmarket.com>
Date: Fri, 08 Jan 1999 21:47:05 GMT
Message-ID: <775uco$rr9$1@nnrp1.dejanews.com>

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.

In article <369620F0.D3F10F2A_at_in.fh-merseburg.de>, Torsten Schuelert <torsten.schuelert_at_in.fh-merseburg.de> wrote:
> We have Oracle 8.04 / Windows NT 4.0 and Oracle Webserver 2.0.
> The acces from Webbrowser (IE, Netscpae or Opera) is slow.
> We found out that the first "select" instruction in a java-cgi-program
> is slower than all the others in this program.
> It does not depend on complexity of the select instruction or the
> dimension of the database.
>
> Any ideas?
>
> Thanks for everything.
>
> Torsten
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 08 1999 - 15:47:05 CST