Reduce lag time retreiving data from a remote host

Reduce lag time retreiving data from a remote host

Postby 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.
innovashop
 
Posts: 1
Joined: Mon 20 Aug 2012 16:42

Re: Reduce lag time retreiving data from a remote host

Postby 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/docs/?Asynchronous.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/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlDataReader.html
b) when working with MySqlDataTable, pay attention to Sequential Fetch Mode.
http://www.devart.com/dotconnect/mysql/docs/DataTable.html#sequential
Pinturiccio
Devart Team
 
Posts: 1869
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL