Re: MTS/Oracle8/ODBC

Have you tried Oracle's ODBC driver?

sm

On Fri, 23 Jul 1999 10:27:09 +0100, "Julian Cowking" <jcowking_at_hrmsoftware.com> wrote:

>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 Mon Jul 26 1999 - 18:56:38 CDT