MySQL Forums
Forum List  »  MySQL Workbench

Re: Getting the execution time of a query
Posted by: bernard yip
Date: July 09, 2012 01:29AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Getting the execution time of a query
7572
July 09, 2012 01:29AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.