The 10 seconds delay in the remote connection to MySQL via MySqlConnection

The 10 seconds delay in the remote connection to MySQL via MySqlConnection

Postby Natalya » Tue 16 Jan 2007 10:16

We use your MySqlDirect.NET data provider Standard

While connaecting remotely to MySql installed on Windows XP computer we have 10 seconds delay.

The delay takes place when method MySqlConnection.Open is invoked.

What can be the matter of such delay?

and how the problem can be solved?

Can you point out the most probable ways of solving this problem?

Thank you
Natalya
 
Posts: 2
Joined: Tue 16 Jan 2007 08:24
Location: Russia

Postby Alexey » Tue 16 Jan 2007 11:45

Looks like network problems. Try to check whether this delay take place if you set Direct=false in the connection string.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Natalya » Tue 16 Jan 2007 14:03

Alexey wrote:Looks like network problems. Try to check whether this delay take place if you set Direct=false in the connection string.


i've tried... does not help.

It is interesting, that there is no delay when we remotely connect to MySQL installed on Linux OS .

Delay takes place only when we connect to PC with WinXP installed on it.

So you think it is a network problem?

Have you ever heard this problem to be reported before?
Natalya
 
Posts: 2
Joined: Tue 16 Jan 2007 08:24
Location: Russia

Postby Alexey » Wed 17 Jan 2007 12:21

We could have been reported similar problem earlier, but the real reason of such delay may be different.
Unfortunately, we cannot provide general advice on configuring network because this topic is beyond the scope of our support program.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby jsndgl » Sun 11 Feb 2007 17:35

I am experiencing the same issue and obtaining a quick connection is critical to our application.

All other network performance is fine. I really don't see any problems with our network. Once the connection to MySQL is made speed is not an issue. It is simply the open method that is taking a long time.

What type of network issues are you suggesting causes the problem? I'm not looking for advice on how to resolve our network issues, but if you are aware that network issues cause the delay then you should be able to provide an example of the type of network issue you have seen to cause this delay.

MySQL is installed on XP and our application connects from WinCE.

Has anyone else encountered this problem and was able to resolve it?
jsndgl
 
Posts: 1
Joined: Wed 24 Jan 2007 00:19

Postby Alexey » Wed 14 Feb 2007 15:52

Try to check the delay with any other tool.
Observe with a sniffer what is going on in your network.
What version of MySQLDirect .NET do you use?
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for MySQL