I'm doing an application that works with an online mysql database.
Here is a sample of my code:
Dim adapter As New MySqlDataAdapter("select * from my_table order by code", "server=my_server;User Id=me;password=password;Persist Security Info=True;database=database") Dim my_table = New DataTable adapter.fillj(my_table)
On the last line, the application freezes until the DataTable is filled. I realized that it doesn't happen with a local database.
Is there a way to avoid this?