Reduce lag time retreiving data from a remote host

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
innovashop
Posts: 1
Joined: Mon 20 Aug 2012 16:42

Reduce lag time retreiving data from a remote host

Post by innovashop » Mon 20 Aug 2012 16:45

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.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: Reduce lag time retreiving data from a remote host

Post by Pinturiccio » Tue 21 Aug 2012 13:49

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

Post Reply