473,320 Members | 1,909 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Oracle performance with C#

Guy
We have an old DLL written with Visual C++, no MFC. The DLL construct a
fairly complex sql dynamically and send it to an Oracle 9 or 10 server.
We recently ported the code as a web service written in C# with .NET
1.1. We ran comparative performance statistics to ensure that our new
implementation would be as fast as the 10 years old, very mature and
very optimized version. Here are the results:

When the SQL is first send:
C++ : avg=655ms, std=1100ms
C# : avg=672ms, std=1146ms

When we repeat the same search again:
C++ : avg=178ms, std=166ms
C# : avg=78ms, std=66ms

Our conclusions are:
- when the sql if first send, a "context switch" seems to occur on
the server
- the time to process the SQL seems identical for both C# and C++
- if the SQL was already send on the current connection, the
performance is much faster

Question:
- why is .NET framework twice faster than C++ to "pump" back the data
of an already submitted SQL? The transport should be done by OCI
library using tcp/ip socket in both approach?

(Measurement was done in both case thru call of QueryPerformanceCounter
and ...Freq.

Mar 21 '06 #1
0 1139

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Seung Y. Kim | last post by:
Hi everyone. I am having a big performance issue with my ASP application with Oracle database. The application itself is a very database-generic one, so I can switch from Access to SQLServer...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
8
by: =?Utf-8?B?RGF2aWQrKw==?= | last post by:
Hi, I have been developing Web Services in VS2005. Usually I use the built in server in VS2005 to test and develop the Web Service. However I now want to make this Web Service available to...
2
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers:...
1
by: kprawin | last post by:
I've developed web applications using php and MySQL. Currently I wish to migrate towards oracle. And I need the steps to connect Oracle10g with PHP. Since Im new to oracle please provide sample code...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.