MySQL Forums
Forum List  »  Connector/ODBC

Re: Slow App when db is not on client machine
Posted by: Christian Schlepphorst
Date: April 06, 2005 12:17PM

Hi,

we had a similar problem (maybe the same?) when connecting to MySQL from a remote machine: 5-10 seconds delay to establish the connection; the delay was not there when working locally, or when connecting with mysql.exe remotely.

It turned out to be a problem with DNS resolution, i.e. the DNS service on the MySQL server was not working properly, and MySQL was waiting for DNS before answering the query. Have you tried skipping DNS from MySQL by setting the "skip name resolution" option in the MySQL Admin?

Options: ReplyQuote


Subject
Written By
Posted
Re: Slow App when db is not on client machine
April 06, 2005 12:17PM
April 14, 2005 10:58AM
April 15, 2005 09:38AM
April 15, 2005 02:17PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.