CODEWITHSUNDEEP
c#mysqlwinformsnetwork-programming
Andrew
Andrew

Reputation: 7768

Improve mysql performance over network

I have server with Centos and mysql and another client with Windows 7 that updates the server ovet the network.

Is there any way performance could be improved? For example, to update 100,000k records locally, it takes like 1minute, to do it over the network, it takes 15 minutes!

Upvotes: 0

Views: 720

Answers (1)

Joshua Martell
Joshua Martell

Reputation: 7212

The mysql client takes a --compress switch that will compress traffic over the network. It sounds like this might be helpful for you. Information about the C# driver version is documented under UseCompression.

Upvotes: 1

Related Questions