Performance problem with MissingSchemaAction.AddWithKey

Performance problem with MissingSchemaAction.AddWithKey

Postby ThorstenSt » Tue 29 Nov 2011 10:35

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
ThorstenSt
 
Posts: 7
Joined: Thu 24 Nov 2011 09:55

Postby Pinturiccio » Tue 29 Nov 2011 13:54

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.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Postby Pinturiccio » Wed 14 Mar 2012 09:12

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.
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44

Postby Pinturiccio » Fri 16 Mar 2012 07:20

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
Pinturiccio
Devart Team
 
Posts: 2024
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for Oracle