DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?

420111Apr 28 2004 — edited May 18 2004

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, I made 1000 calls and computed the average).
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

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2004

Added on Apr 28 2004

#oracle-provider-for-ole-db, #windows-and-net

14 comments

1,031 views