performance bench mark - Direct mode vs OCI mode

performance bench mark - Direct mode vs OCI mode

Postby slaxman » Wed 20 Oct 2010 20:05

Do you have a bench mark comparing performance of Direct mode vs OCI mode. In addition, can you give some guidelines on how the implementation can take advantage of Direct mode to improve query perf.

thanks
slaxman
slaxman
 
Posts: 47
Joined: Wed 16 Sep 2009 20:09
Location: United States

Postby Shalex » Fri 22 Oct 2010 14:45

The performance of Direct Mode should not differ essentially from the performance of OCI Mode because all operations are executed at the server side in both cases. The only thing you should take into account during development is the limitations of Direct Mode that are listed here: http://www.devart.com/dotconnect/oracle/docs/?DirectMode.html.
Shalex
Devart Team
 
Posts: 7539
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for Oracle