Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Compare Performance Connection Open ODP / Devart

TobselAug 2 2023

Hello,

many years ago there was no (managed) ODP Driver from Oracle so we searched for an alternative and found it in the Devart ADO.NET Driver for Oracle. They have a direct mode for many years that allows to connect to Oracle without an Installation (OCI). We use that driver for years but now want to move to the original (managed) driver from Oracle.

I tried the new Version 23.2 Dev.

I made a litte sampe to compare the connection open, but I cannot upload a zip or gz file. If you want/need I can send you the solution

Opening 10 Connections via Async/Await Looks like that for ODP:

An it looks like that for Devart

The ODP works without blocking the UI (now real Async/Await) where Devart blocks the UI, takes 1879ms for the whole Button Click Event.

The Question I have is: Why is a single Connection Open so much faster with Devart (~200ms) than with ODP (~600ms)?

Thank you very much,

Tobias

Comments
Post Details
Added on Aug 2 2023
6 comments
811 views