Page 1 of 1
Performance issue when using data adapter
Posted: Fri 26 Mar 2010 13:50
by cis_dev
Is there a way to turn off the execution of the SHOW TABLE STATUS and SHOW VARIABLES LIKE commands that run every time a query is executed against tables with auto_increment columns?
We are seeing a pretty significant performance issue due to these 'extra' queries running.
Posted: Tue 30 Mar 2010 13:25
by Shalex
If OracleDataAdapter.MissingSchemaAction is set to MissingSchemaAction.Add, the additional queries will not be executed. This behaviour will be implemented in the next build. I will post here when it is available for download.
Posted: Wed 31 Mar 2010 08:22
by Shalex
Currently, please use (set to false) the static property of the MySqlDataAdapter class to disable additional roundtrip to the server that requests the autoincremented value:
Code: Select all
public static bool RetrieveAutoIncrementSeed { get; set; }
Posted: Thu 01 Apr 2010 08:31
by Shalex
dotConnect for MySQL v 5.70 is released!
It can be downloaded from
http://www.devart.com/dotconnect/mysql/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?p=55120 .