mysql query building output taking a long time
Posted
by user121196
on Stack Overflow
See other posts from Stack Overflow
or by user121196
Published on 2010-05-26T04:21:55Z
Indexed on
2010/05/26
4:31 UTC
Read the original article
Hit count: 301
mysql
|Performance
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)
© Stack Overflow or respective owner
