Devart Forums

Hello
As I can reduce the time lag when trying to retrieve data from a remote MySQL server?. My application uses the method "ExecuteNonQuery" component "dotConnect for mysql", but when there is a lot of data, the application freezes 5-8 seconds, is there any way to avoid or reduce that?
Thank you.

1. To keep the application available for users, you can use the asynchronous Begin/End-
ExecuteNonQuery method instead of ExecuteNonQuery: http://www.devart.com/dotconnect/mysql/ ... onous.html.
2. You can also reconsider the data retrieval approach. For example:
a) the fastest way of reading is using MySqlDataReader;
http://www.devart.com/dotconnect/mysql/ ... eader.html
b) when working with MySqlDataTable, pay attention to Sequential Fetch Mode.
http://www.devart.com/dotconnect/mysql/ ... sequential