Performance issue when using data adapter

cis_dev · Post by **cis_dev** » Fri 26 Mar 2010 13:50

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.

Shalex · Post by **Shalex** » Tue 30 Mar 2010 13:25

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.

Shalex · Post by **Shalex** » Wed 31 Mar 2010 08:22

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; }

Shalex · Post by **Shalex** » Thu 01 Apr 2010 08:31

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 .