Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2004

    Unanswered: OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?


    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 took 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!

  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    Your Oracle numbers are significantly better than average, and your SQL Server numbers are about right for a workstation. The difference that I see is usually greater than what you are seeing.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts