Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

share|improve this question
    
Please post the query that is taking long to run. Also please tell us if the table/tables involved are MyISAM, InnoDB, or both. –  RolandoMySQLDBA Sep 21 '12 at 7:10
    
Also, what is "slow"? 1 second, 10 minutes, a lifetime? –  Phil Sep 21 '12 at 7:54

1 Answer 1

up vote 0 down vote accepted

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.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.