List:General Discussion« Previous MessageNext Message »
From:Fred Lindberg Date:April 25 1999 5:56pm
Subject:Re: Connection over network
View as plain text  
>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)


Thread
Re: Connection over networkLZW25 Apr
  • Re: Connection over networkSasha Pachev25 Apr
Re: Connection over networkFred Lindberg25 Apr