Home -> Usenet -> comp.databases.oracle -> OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?

OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?

From: Florin <fmicle_at_yahoo.de>
Date: 27 Apr 2004 19:44:38 -0700
Message-ID: <e54ea115.0404271844.73035739_at_posting.google.com> 





Hi,



I am experiencing some problems accessing an Oracle database through
OLE DB from an MTS application using OpenWithServiceComponents (which
is supposed to give me connection pooling).
When I connect to a SQL Server database it only takes 3.1 ms to open a
connection, while with Oracle it takes 15.5 ms (both DB's running on
the same machine).


Am I doing something wrong, am I missing something here?
I have tried to use the plain Open method, but in this case it takes
5.4 ms with SQL Server and 31.4 ms with Oracle.
Is Oracle really that much slower when accessing it through OLE DB?



Thanks for any advice/hints!


Florin
Received on Wed Apr 28 2004 - 04:44:38 CEST












Original text of this message