Johann Kropf <Johann.Kropf_at_gmx.net> wrote in message news:<3dc8bf0f$0$25572$91cee783_at_newsreader02.highway.telekom.at>...
> 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.
7 seconds does sound a little too slow but it's still quite insignificant.
The reason it seems to be faster to connect to an Informix database is
probably because Informix uses a multi-threaded architecture. Each session
is created as a thread that runs in the address space of the existing server
process. Oracle uses a multi-process architecture. In a dedicated server
configuration, each time you connect to Oracle a new server process needs
to be loaded into memory. Obviously it's faster to create a thread than loading
a separate process. If you are using dedicated servers, it partly explains
why it takes so much longer to connect to your database. You can try multithreaded
servers. That may be faster.
Received on Wed Nov 06 2002 - 20:51:25 CST
