Page 1 of 1

Oracle direct mode vs OCI

Posted: Sat 25 Mar 2017 17:17
by cointec
Hello, I'm doing some test of performance with Unidac and Oracle direct and OCI mode.

In our test, direct mode is between 20% and 25% slower than using OCI dll. Is this behaviour expected or i'm mising something in connection configuration?

Re: Oracle direct mode vs OCI

Posted: Wed 12 Apr 2017 12:36
by MaximG
We constantly work on our products performance issues. Our internal tests show a small performance drop when using Direct mode comparing with Oracle Client (not exceeding 10 % in some cases. For a more detailed investigation we need to conduct some tests as close as possible to your environment. Therefore, we will need DDL scripts for creating tables used in the test, the samples of their filling, as well as a small snippet demonstrating the difference in performance between Direct and OCI Mode