OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Florin
    #1

    OpenWithServiceComponents 5 times slower for Oracle than for SQL Server?

    Hi,

    I am experiencing some problems accessing an Oracle database through
    OLE DB from an MTS application using OpenWithService Components (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
    Tags: None
    • Jim Kennedy
      #2
      Re: OpenWithService Components 5 times slower for Oracle than for SQL Server?


      "Florin" <fmicle@yahoo.d ewrote in message
      news:e54ea115.0 404271844.73035 739@posting.goo gle.com...
      Hi,
      >
      I am experiencing some problems accessing an Oracle database through
      OLE DB from an MTS application using OpenWithService Components (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
      What about subsequent times? Is the machine (server) swapping? MS
      SqlServer is known to take all the ram on the machine and that could do it.
      (try shuting down the instance and see if it makes a difference). It is
      hard to say since you are going through a lot of non-native stuff. So who
      knows what it is doing.
      Jim


        Comment

        • Florin
          #3
          Re: OpenWithService Components 5 times slower for Oracle than for SQL Server?

          "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<B7Fjc.135 $Rd4.61591@attb i_s51>...
          "Florin" <fmicle@yahoo.d ewrote in message
          news:e54ea115.0 404271844.73035 739@posting.goo gle.com...
          Hi,

          I am experiencing some problems accessing an Oracle database through
          OLE DB from an MTS application using OpenWithService Components (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
          What about subsequent times? Is the machine (server) swapping? MS
          SqlServer is known to take all the ram on the machine and that could do it.
          (try shuting down the instance and see if it makes a difference). It is
          hard to say since you are going through a lot of non-native stuff. So who
          knows what it is doing.
          Jim
          What I did was to open and close the connection 1000 times and take
          the average response time for this operation. No DB queries were
          involved. I have 1 GB RAM, there is also no swapping involved. It just
          seems that the connection pooling is still much slower in Oracle than
          in SQL Server (about 5 times) and I would like to know why...

          Florin

            Comment

            • Frank van Bortel
              #4
              Re: OpenWithService Components 5 times slower for Oracle than forSQL Server?

              Florin wrote:
              "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<B7Fjc.135 $Rd4.61591@attb i_s51>...
              >
              >>"Florin" <fmicle@yahoo.d ewrote in message
              >>news:e54ea115 .0404271844.730 35739@posting.g oogle.com...
              >>
              >>>Hi,
              >>>
              >>>I am experiencing some problems accessing an Oracle database through
              >>>OLE DB from an MTS application using OpenWithService Components (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
              >>
              >>What about subsequent times? Is the machine (server) swapping? MS
              >>SqlServer is known to take all the ram on the machine and that could do it.
              >>(try shuting down the instance and see if it makes a difference). It is
              >>hard to say since you are going through a lot of non-native stuff. So who
              >>knows what it is doing.
              >>Jim
              >
              >
              What I did was to open and close the connection 1000 times and take
              the average response time for this operation. No DB queries were
              involved. I have 1 GB RAM, there is also no swapping involved. It just
              seems that the connection pooling is still much slower in Oracle than
              in SQL Server (about 5 times) and I would like to know why...
              >
              Florin
              Use IPC (or even better BEQ) stack instead of TCP/IP.

              --

              Regards,
              Frank van Bortel

                Comment

                • Jim Kennedy
                  #5
                  Re: OpenWithService Components 5 times slower for Oracle than for SQL Server?


                  "Florin" <fmicle@yahoo.d ewrote in message
                  news:e54ea115.0 404280815.3aabc 529@posting.goo gle.com...
                  "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message
                  news:<B7Fjc.135 $Rd4.61591@attb i_s51>...
                  "Florin" <fmicle@yahoo.d ewrote in message
                  news:e54ea115.0 404271844.73035 739@posting.goo gle.com...
                  Hi,
                  >
                  I am experiencing some problems accessing an Oracle database through
                  OLE DB from an MTS application using OpenWithService Components (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
                  What about subsequent times? Is the machine (server) swapping? MS
                  SqlServer is known to take all the ram on the machine and that could do
                  it.
                  (try shuting down the instance and see if it makes a difference). It is
                  hard to say since you are going through a lot of non-native stuff. So
                  who
                  knows what it is doing.
                  Jim
                  >
                  What I did was to open and close the connection 1000 times and take
                  the average response time for this operation. No DB queries were
                  involved. I have 1 GB RAM, there is also no swapping involved. It just
                  seems that the connection pooling is still much slower in Oracle than
                  in SQL Server (about 5 times) and I would like to know why...
                  >
                  Florin
                  Sounds like your connection pooling thing isn't doing its stuff.
                  Jim


                    Comment

                    • Florin
                      #6
                      Re: OpenWithService Components 5 times slower for Oracle than for SQL Server?

                      Frank van Bortel <fvanbortel@net scape.netwrote in message news:<c6ovqf$fj i$1@news4.tilbu 1.nb.home.nl>.. .
                      Florin wrote:
                      >
                      "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<B7Fjc.135 $Rd4.61591@attb i_s51>...
                      >"Florin" <fmicle@yahoo.d ewrote in message
                      >news:e54ea115. 0404271844.7303 5739@posting.go ogle.com...
                      >
                      >>Hi,
                      >>
                      >>I am experiencing some problems accessing an Oracle database through
                      >>OLE DB from an MTS application using OpenWithService Components (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
                      >
                      >What about subsequent times? Is the machine (server) swapping? MS
                      >SqlServer is known to take all the ram on the machine and that could do it.
                      >(try shuting down the instance and see if it makes a difference). It is
                      >hard to say since you are going through a lot of non-native stuff. So who
                      >knows what it is doing.
                      >Jim

                      What I did was to open and close the connection 1000 times and take
                      the average response time for this operation. No DB queries were
                      involved. I have 1 GB RAM, there is also no swapping involved. It just
                      seems that the connection pooling is still much slower in Oracle than
                      in SQL Server (about 5 times) and I would like to know why...

                      Florin
                      Use IPC (or even better BEQ) stack instead of TCP/IP.
                      I tried IPC, same results.

                        Comment

                        Previous template Next
                        Working...