Devart Forums

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

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.

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

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