Re: connect slower than on informix

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Wed, 06 Nov 2002 11:31:13 +0200
Message-ID: <aqanj7$aq6$2@ctb-nnrp2.saix.net>

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

What type of connection? IPC? TCP?

Nice that you are giving tech details. Not so nice that you left out that which is really critically important. The type of connections that are being compared.

An IPC connection to Oracel from SQL*Plus (just tried it on a Unix platform), in about a second. Definately not 7 seconds.

Doing it via the listener and TCP.. it can take time, even when done locally. Also true for Informix and others.

--
Billy

Received on Wed Nov 06 2002 - 03:31:13 CST