CODEWITHSUNDEEP
mysqlexecutionmysql-cli
Mateusz G
Mateusz G

Reputation: 1

MySQL query's execution time

When in mysql client prompt I execute a query on a table with over 100k rows:

select * from jmeterschema.tabela_inz;

#I just retrieve data from it.

The execution time shown after executing is e.g 0.12sec, yet the prompt to actually retrieve the data needs around few minutes. Hence my question, what is the real time of an execution. Why do these two differ?

I need it because I am doing databases efficiency comparison - I would be grateful for any tips if I am not doing something right. ;)

Cheers

Well I also tried to do it from mySQL workbench and there execution time is around 0.14 ish, which leads me to conclusion that it is the proper time but I am curious still why mysql-cli needs more time to retrieve the data.

Upvotes: 0

Views: 132

Answers (0)

Related Questions