Why is Microsoft OracleClient faster?

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
Post Reply
janjoker
Posts: 3
Joined: Wed 07 Oct 2009 11:51

Why is Microsoft OracleClient faster?

Post by janjoker » Wed 07 Oct 2009 12:02

I have done a small test to see which driver is faster. Surprisingly the Microsoft driver is even faster than Devart's Direct mode...

Did I miss something?

Check my test project at http://dl.getdropbox.com/u/876668/TestProject1.zip
See also the speeds.png and script.txt in the zip file.

If somebody can tell me what I did wrong I would be very happy.

UPDATE: if I change the test and open the connection first, keep it open until the last command is done, then the Devart connection using the Oracle Client is the fastest connection

Jan

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Thu 08 Oct 2009 13:12

dotConnect for Oracle is faster the provider from Microsoft. Your project tests actually the speed of opening/closing connections. The provider from Microsoft shows better results because you opened connections with dotConnect for Oracle first (probably, Oracle client hashed these connections), and then MS provider used ready-to-use connections. Please try reordering the sequence of methods' execution and call MS provider first.

janjoker
Posts: 3
Joined: Wed 07 Oct 2009 11:51

Post by janjoker » Fri 09 Oct 2009 06:27

You are right.
But I still measure differences.
The Devart driver via the local Oracle Client using TNS seems to be the fastest

Shalex
Site Admin
Posts: 9543
Joined: Thu 14 Aug 2008 12:44

Post by Shalex » Mon 12 Oct 2009 09:01

According to our tests, performance of dotConnect for Oracle in Direct mode is approximately equal to using our provider via OCI.

Post Reply