Performance issue when using data adapter

Performance issue when using data adapter

Postby 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.
cis_dev
 
Posts: 1
Joined: Fri 26 Mar 2010 13:40

Postby 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
Devart Team
 
Posts: 7533
Joined: Thu 14 Aug 2008 12:44

Postby 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
Devart Team
 
Posts: 7533
Joined: Thu 14 Aug 2008 12:44

Postby 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 .
Shalex
Devart Team
 
Posts: 7533
Joined: Thu 14 Aug 2008 12:44


Return to dotConnect for MySQL