Discussion of open issues, suggestions and bugs regarding ADO.NET provider for Oracle
2 posts • Page 1 of 1
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.
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 ... tMode.html.