distal-attribute
distal-attribute
distal-attribute
distal-attribute

Where does get Heidi "network" figures from a query

User, date Message
Written by Joselitux
5 months ago
Category: General
21 posts since Mon, 22 Oct 12
Hi folks!

Executing some long queries Heidi is giving me some numbers about duration and network.
vg:

0,045 sec (+35,131 sec. network)



My guess is that we're having network latency issues
must we improve network performance or I'm missing the point?

Thanks
Written by ansgar
5 months ago
4793 posts since Fri, 07 Apr 06
I'm not 100% sure if you can rely on these details. However, here is how I am counting these both values:
* time that takes mysql_real_query() = query time (0,045 sec)
* time that takes mysql_store_result() = network time (35,131 sec)

Mostly you have long network times on queries which return *much data*. The query itself seems to be ok. The call to mysql_store_result is as far as I know transferring the result over the net.
Written by Joselitux
5 months ago
21 posts since Mon, 22 Oct 12
Thanks ansgar
I Will check if running on server itself we Get better numbers. We were worried a bit because of probable latency issues

Thanks a lot
Written by ansgar
5 months ago
4793 posts since Fri, 07 Apr 06
After the result has "arrived" in the HeidiSQL grid, rightclick the grid, then click "Export grid rows". You will see a roughly calculated size of the whole result. Should be quite much according to 35sec. Or, if it's just a bit, then probably your network connection is slow, or HeidiSQL does the calculation wrong.
 

Please login to leave a reply, or register at first.