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 184.108.40.20613. 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. */
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.