469,286 Members | 2,524 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,286 developers. It's quick & easy.

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 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
Jul 19 '05 #1
5 2286

"Florin" <fm****@yahoo.de> wrote in message
news:e5**************************@posting.google.c om...
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
Jul 19 '05 #2
"Jim Kennedy" <ke****************************@attbi.net> wrote in message news:<B7Fjc.135$Rd4.61591@attbi_s51>...
"Florin" <fm****@yahoo.de> wrote in message
news:e5**************************@posting.google.c om...
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
Jul 19 '05 #3
Florin wrote:
"Jim Kennedy" <ke****************************@attbi.net> wrote in message news:<B7Fjc.135$Rd4.61591@attbi_s51>...
"Florin" <fm****@yahoo.de> wrote in message
news:e5**************************@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.

--

Regards,
Frank van Bortel

Jul 19 '05 #4

"Florin" <fm****@yahoo.de> wrote in message
news:e5**************************@posting.google.c om...
"Jim Kennedy" <ke****************************@attbi.net> wrote in message

news:<B7Fjc.135$Rd4.61591@attbi_s51>...
"Florin" <fm****@yahoo.de> wrote in message
news:e5**************************@posting.google.c om...
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


Sounds like your connection pooling thing isn't doing its stuff.
Jim
Jul 19 '05 #5
Frank van Bortel <fv********@netscape.net> wrote in message news:<c6**********@news4.tilbu1.nb.home.nl>...
Florin wrote:
"Jim Kennedy" <ke****************************@attbi.net> wrote in message news:<B7Fjc.135$Rd4.61591@attbi_s51>...
"Florin" <fm****@yahoo.de> wrote in message
news:e5**************************@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.
Jul 19 '05 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

14 posts views Thread by Steve McLellan | last post: by
87 posts views Thread by John Rivers | last post: by
42 posts views Thread by Paul | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.