Devart Forums

We have found a serious performance problem using the Devart Oracle Driver when we execute the Fill method for a DataAdapter which has been configured with the MissingSchemaAction property set to AddWithKey.

Compared with the ODP.NET Driver for a very simple query (“SELECT DESC FROM TABLE WHERE ID = XX”) ODP.NET needs 1 or 2 milliseconds, but DevArt requires 70-90 milliseconds. For more complex queries the difference increases accordingly.

70 milliseconds does not sound much, but it is at least 35 times slower!! This means that some of our business methods take 15 seconds instead of 0,5.

Is there something we could do to increase the performance? We need the information so we cannot use another MissingSchemaAction value. Our software works with SQL Server and Oracle and they use the same calls.

Thank you in advance
Raul Rodriguez
Team Leader
Babtec Informationssysteme GmbH

Thank you for your report.
We have reproduced the issue. We will investigate the issue and notify you about the results as soon as possible.

We have improved the performance of OracleDataAdapter when using MissingSchemaAction.AddWithKey. We will notify you when the corresponding build of dotConnect for Oracle is available for download.
We will improve performance more in a future.

The new build of dotConnect for Oracle 6.80.325 is available for download now!
It can be downloaded from http://www.devart.com/dotconnect/oracle/download.html (trial version) or from Registered Users' Area (for users with valid subscription only).
For more information, please refer to http://www.devart.com/forums/viewtopic.php?t=23639