Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Florin <fmicle_at_yahoo.de>
Date: 28 Apr 2004 20:04:31 -0700
Message-ID: <e54ea115.0404281904.4afa5ad@posting.google.com>


Frank van Bortel <fvanbortel_at_netscape.net> wrote in message news:<c6ovqf$fji$1_at_news4.tilbu1.nb.home.nl>...
> Florin wrote:
>
> > "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<B7Fjc.135$Rd4.61591_at_attbi_s51>...
> >
> >>"Florin" <fmicle_at_yahoo.de> wrote in message
> >>news: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
> >>
> >>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. Received on Wed Apr 28 2004 - 22:04:31 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US