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