>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.
(Frederik Lindberg, Infectious Diseases, WashU, St. Louis, MO, USA)