MySQL Forums
Forum List  »  Newbie

Slowest Queries
Posted by: iago sarrea
Date: June 27, 2022 06:24AM

i am reading many foruns but i dont find an explanation for what is happenning,
i have a table over 50kk lines, and when i make a query comming by php page, this query takes more than 3000 seconds to be executed, but if execute the same query direct in the workbench this query is taking less than 50 seconds to be executed.


why have i this difference between the query executed by php script and executed in the workbench?

query: select count(distinct(Col_A)),ID,NAME from table where data between `2022-06-24 00:00:00` and ` 2022-06-24 23:59:59` group by ID, NAME

Options: ReplyQuote


Subject
Written By
Posted
Slowest Queries
June 27, 2022 06:24AM
June 27, 2022 08:59AM


Sorry, only registered users may post in this forum.

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.