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

Where does get Heidi "network" figures from a query

User, date Message
Written by Joselitux
10 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
10 months ago
5023 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
10 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
10 months ago
5023 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.
Written by itshoMoney, Euro
2 months ago
7 posts since Tue, 10 Jun 14
Hi.

that's quite weird.
i'm getting this on remote (connected to server IP):
Affected rows: 0 Found rows: 14,560 Warnings: 0 Duration for 1 query: 23.250 sec. (+ 71.828 sec. network)


And this on local (connected to 127.0.0.1):
Affected rows: 0 Found rows: 14,560 Warnings: 0 Duration for 1 query: 23.884 sec. (+ 69.374 sec. network)

i'm using HeidiSQL 8.3.0.4694
MySQL server version is 5.7.4
Written by user01
2 months ago
1 posts since Wed, 16 Jul 14
Is there any way of decreasing this network latency? I want to optimise my queries as well?

Thanks.
Written by ansgar
2 months ago
5023 posts since Fri, 07 Apr 06
Be sure to have "Compressed protocol" activated in your session.

Apart from that, increase your bandwidth to your server.
 

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