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
Performance problem with MissingSchemaAction.AddWithKey
-
- Posts: 7
- Joined: Thu 24 Nov 2011 09:55
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
-
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
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
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