Duration for multiple queries shows duration for last query

David Marcus's profile image David Marcus posted 3 years ago in General Permalink

If I run multiple queries together, HeidSQL says something like "Duration for 2 queries: 5.766 sec." But the time shown is actually only the time for the last query. Version 11.2.0.6213. MariaDB 10.3.25.

ansgar's profile image ansgar posted 3 years ago Permalink

Actually the duration of all queries is summed up. I ran a test to ensure this works:

SELECT SLEEP(3);
SELECT SLEEP(5);
/* Affected rows: 0  Found rows: 2  Warnings: 0  Duration for 2 queries: 8,031 sec. */

Probably your first query was very quick?

David Marcus's profile image David Marcus posted 3 years ago Permalink

Here is my test. For the first one, I had "Send batch in one go" checked. For the second one, I had "Send queries one by one" checked.

SELECT SLEEP(3);SELECT SLEEP(5);;
/* Affected rows: 0  Found rows: 2  Warnings: 0  Duration for 2 queries: 3.000 sec. */
SELECT SLEEP(3);
SELECT SLEEP(5);
/* Affected rows: 0  Found rows: 2  Warnings: 0  Duration for 2 queries: 8.015 sec. */
Code modification/commit 940bbb7 from Ansgar Becker <anse@heidisql.com>, 3 years ago, revision 6272
Fix logged queries duration in "one go" mode. See https://www.heidisql.com/forum.php?t=37878
ansgar's profile image ansgar posted 3 years ago Permalink

That was indeed a bug in HeidiSQL. I just fixed it for the next build.

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