What SQL query execution time is considered long?

Question

MySQL

What queries are considered slow and require optimization? If a request takes 0.5-0.2 seconds, is it considered slow? Or 0.009-0.001 seconds.

Answer 1

It depends on the task and on the request.
I remember in one project a request that ran for 5 hours was considered normal ...

Answer 2

As long as you / the client are satisfied with the execution time - the request is fast enough, as soon as it stops - it's time to do something. Often it is enough to add the correct index to the table so that the query starts to work an order of magnitude faster.
But as correctly noted above, some queries cannot be made fast enough due to the specifics of the tasks being performed.

Answer 3

Often, it all depends on what you need to implement a complex system or a lightweight desktop for yourself, but you should start from 1 second. Requests executing more than 1s are large requests