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
5  2498 
"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
"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
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
"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
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. This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Ton |
last post by:
I have a question about connectivity between different databases.
Oracle, DB2400 and SQL_server.
It is easy to integrate application products that are running on
different DB platforms?
What...
|
by: Steve McLellan |
last post by:
Hi,
Sorry to repost, but this is becoming aggravating, and causing me a lot of
wasted time. I've got a reasonably large mixed C++ project, and after a
number of builds (but not a constant...
|
by: John Rivers |
last post by:
Hello everybody,
I just wondered if anybody else has noticed this?
It takes around 6 seconds to start debugging a very simple ASPX page
with VS.NET whereas VB6 takes under 0.5 seconds, even...
|
by: Paul |
last post by:
Anyone know where I can find some good resources to help us choose between
SQL and Oracle ( Progress Openedge as well ) . Any comments on what you
would choose ?? We are creating a new Warehouse...
|
by: wizofaus |
last post by:
I have a chunk of code which is essentially
IDbCommand cmd = db.CreateCommand();
cmd.CommandText = "SELECT X, Y, Count(*) FROM Foo WHERE Z = 1 GROUP BY
X, Y";
using (IDataReader reader =...
|
by: anneeny |
last post by:
Hi there... My company has implemented Oracle Financials and Project applications in 1999 as a part of Y2K project. Oracle 11.0.3 Applications are implemented in 3-tier configuration as per the...
|
by: Florin |
last post by:
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...
|
by: Chris Hohmann |
last post by:
"Mujahid" <mujahid@iqura.netwrote in message
news:OuhAYozFAHA.271@cppssbbsa04...
me
Oracle Database Utilities (Data Pump/SQL Loader)
http://otn.oracle.com/products/database/utilities/index.html...
|
by: sathyguy |
last post by:
when i type the below in my RHEL AS 4's Firefox 1.5
http://appsworld.ncc.com:7777/forms/...&form=test.fmx
iam getting the below error...
The requested URL /forms/frmservlet was not found on...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |
