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.
Reduce lag time retreiving data from a remote host
-
innovashop
- Posts: 1
- Joined: Mon 20 Aug 2012 16:42
-
Pinturiccio
- Devart Team
- Posts: 2420
- Joined: Wed 02 Nov 2011 09:44
Re: Reduce lag time retreiving data from a remote host
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
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