3

I'm doing this query select * from rentals. This table has more than 10,000 rows and it takes more than 4 minutes to retrieve the results.

But I get this time after I get the results: 10000 rows in set (0,05 sec).

Do you know how to get the real execution time?

I try with:

set profiling = 1;
select * from rentals;
show profiles;

But also appears that the query duration is: 0,5080950.

2
  • Try a similar query with a smaller result, set such as select count (*) from rentals. How long does that take to return? Commented Feb 22, 2016 at 0:46
  • It shows: 1 row in set (0,02 sec).
    – Jakex
    Commented Feb 22, 2016 at 11:23

1 Answer 1

4

In all probability, your query takes half a second to run, but it takes a lot more time to display all the results.

The latter depends on the speed of your network and that of your computer and is not really relevant from a performance tuning perspective.

To answer your question, the query execution time (0.5 seconds) is the execution time.

0

Not the answer you're looking for? Browse other questions tagged or ask your own question.