Why is Microsoft OracleClient faster?

Why is Microsoft OracleClient faster?

Postby 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
janjoker
 
Posts: 3
Joined: Wed 07 Oct 2009 11:51

Postby 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.
Shalex
Devart Team
 
Posts: 7290
Joined: Thu 14 Aug 2008 12:44

Postby 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
janjoker
 
Posts: 3
Joined: Wed 07 Oct 2009 11:51

Postby 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.
Shalex
Devart Team
 
Posts: 7290
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle