views:

11

answers:

0

I have a simple query that does

 select * 
   from t 
  limit 1; 

on a remote mysql server.

I use squirrel(mysql client) to run it, it shows:

Query 1 of 1 elapsed time (seconds) - Total: 22.047, SQL query: 1.047, Building output: 21

why does building output take such a long time? what does this process do? when running from mysql command line, the whole process takes 0.3 secs (also remotely)