Re: Getting the execution time of a query

[bernard yip]

Hi Mike,

Then would you know what is the fetch time for?
So if i want to benchmark my queries I will only use the duration as the time needed to execute the query and get the results? Just like in the command line client?

I'm still quite new to using MySQL Workbench.

P.S I actually read that the duration is the time needed to execute the query, which your reply confirmed what it is. But the fetch is the time taken to retrieve the data. Should that not be included in the execution time?

P.P.S I realize when executing different queries with the same results the fetch time is very different (E.g. OR VS IN comparison, IN has a slower duration but faster fetch and vice versa for OR) How should i compare these situations? Still by the duration?

Thanks in advance for clearing my doubts :)



Edited 2 time(s). Last edit at 07/09/2012 01:44AM by bernard yip.