MySQL slow sending data I have a large table that frequently sends 3,000 rows of data to a client.  

The longest wait state is Sending data.  I would like to minimize this if possible!

Is there a foolproof way of doing so?
Send fewer rows to the client.

Send less data per row to the client.

Compress the data from the server to the client.

Note that there seems to be a raging argument on the web as to the meaning of "Sending data".  Some day that it might actually mean the prior step.