Oracle direct mode vs OCI

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
cointec
Posts: 50
Joined: Fri 11 Dec 2015 11:02

Oracle direct mode vs OCI

Post by cointec » Sat 25 Mar 2017 17:17

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?

MaximG
Devart Team
Posts: 1822
Joined: Mon 06 Jul 2015 11:34

Re: Oracle direct mode vs OCI

Post by MaximG » Wed 12 Apr 2017 12:36

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

Post Reply