Re: Duration vs fetch issue

[Mike Lischke]

Hi,

it's surely possible, even it looks a bit strange. If the server is slow(er) execute a query you will see a higher execution time compared to a faster one. If there is no result to return (or a very small set) then the fetch time is very small (often much smaller than the execution time, e.g. if you have a complex query that returns only a small result).

Your understanding of the terms is correct. Just try again with something that takes longer to execute and with larger result sets. So small times are usually not very reliable.

Mike

Mike Lischke, MySQL Developer Tools
Oracle Corporation

MySQL Workbench on Github: https://github.com/mysql/mysql-workbench
On Twitter: https://twitter.com/MySQLWorkbench
On Slack: mysqlcommunity.slack.com (#workbench)
Report bugs to http://bugs.mysql.com
MySQL documentation can be found here: http://dev.mysql.com/doc/refman/8.0/en/