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.
Duration for multiple queries shows duration for last query
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>,
4 years ago,
revision 11.2.0.6272
Fix logged queries duration in "one go" mode. See https://www.heidisql.com/forum.php?t=37878
Please login to leave a reply, or register at first.