Re: Slow App when db is not on client machine
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?
Subject
Written By
Posted
Re: Slow App when db is not on client machine
April 06, 2005 12: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.