From: Fred Lindberg
Date: April 25 1999 5:56pm
Subject: Re: Connection over network
List-Archive: http://lists.mysql.com/mysql/2353
Message-Id: <19990425175911.30092.qmail@id.wustl.edu>
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

>lot of results, you will see a loss. The only way to know what would
>happen is very careful system monitoring, and well-designed benchmarks.

One thing is that the overhead of creating a connection is larger over
the network. Make sure your program doesn't connect/close more than
necessary. The protocol supports compression. This can yield
considerable savings if you move a lot of data.

Obviously, a network connection is less reliable than connecting to a
local server via a domain socket. Make sure you use the
mysql_store/use_result that's most appropriate.


-Sincerely, Fred

(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)