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.
Performance issue when using data adapter
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; }
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 .
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 .