MTS/Oracle8/ODBC

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 Fri Jul 23 1999 - 04:27:09 CDT