Re: MTS/Oracle8/ODBC

Julian,

You don't actually describe the architecture you are working with. Is the Oracle on UNIX or NT? Also, what version of Oracle?

BTW I understand you don't need MTS on NT: there is only a single process and this multi-threads anyway. (If the Oracle is on NT maybe you should try removing the MTS parameters? But I dn't know this.)

Len

>Hi,
>
>I'm writing and application using MTS and connecting to either SQL Server 7
>or Oracle database (depending upon client's preference).
>
>Although the performance of both databases is comparible, there is one area
>where using an Oracle database is proving much slower. This is caused when
>establishing an ODBC connection (using Microsoft's ODBC driver for Oracle)
>from MTS. It takes AGES (about 2secs)! This proves to be a problem because a
>new connection is required *per process* - and my application uses many
>processes (many MTS packages) - so, if a user has been hanging about for a
>while (more than 60 seconds or whatever the 'timeout' for pooled ODBC
>connections is) the execution of the next request will take a long time to
>complete since, maybe, 3 connections need to be established.
>
>Now MTS caches ODBC connections and, when the connection is cached the
>performance is, as you would expect, excellent. The problem is when the
>connection has not been used for a while (60 seconds by default) the
>connection is torn down (to free resources) and the next request will
>require the creation of another connection.
>
>So, my question - is there a way to speed up the time required to establish
>a connection to an Oracle database from ODBC/MTS?
>
>Many thanks,
>
>Julian
>
>
>
Received on Sat Jul 24 1999 - 07:18:16 CDT