Re: connect slower than on informix (Solution)

From: Johann Kropf <Johann.Kropf_at_gmx.net>
Date: Thu, 07 Nov 2002 16:28:23 +0100
Message-ID: <3dca8698$0$23666$91cee783@newsreader02.highway.telekom.at>

Johann Kropf wrote:
> why is the connect to oracle slower than to informix?
> informix takes about 1 second and oracle about 7 seconds.
> tested with sqlpus for oracle and isql for informix.
>
> we have oracle 8.1.7 and informix dynamic server 7.31.
>
> the oracle database runs on an ibm p-series 660 6h1, 5 GB memory, 4
> processors of type rs64 IV 600 Mhz, with 150 users connected to that
> server.
>
> the informix database runs on an ibm rs6000, 1 GB memory, 4 processors
> of type powerpc 601, 50 users connected to that server.
>

now it run's fast.
the solution was to write the line tcp.nodelay=YES in the protocol.ora on the server and to restart the TnsListener.

Thank's for your answers! Received on Thu Nov 07 2002 - 09:28:23 CST