From: Dan Nelson
Date: January 24 2005 4:56pm
Subject: Re: Connection performance, suggestions?
List-Archive: http://lists.mysql.com/mysql/178888
Message-Id: <20050124165606.GD33972@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Jan 24), Larry Lowry said:
> Ok I changed my connection string to use the IP of the mySql box and
> added my workstation to the hosts file on the server.  Same problem. 
> The tests ran at the same slow pace.
> 
> I am really curious, what was the logic of adding the workstation ip
> to the hosts file on the server?

If windows wasn't caching the DNS name for some reason and had to ask
your DNS server every time a connection was made, hardcoding the IP on
the client and adding is to the hosts file on the server would bypass
DNS lookups on both ends.

-- 
	Dan Nelson
	dnelson@stripped