A
A
Alexey2020-05-18 22:34:31
PHP
Alexey, 2020-05-18 22:34:31

Why query in PhpMyAdmin is faster than through php?

Hello! I have a simple piece of php code. This is a normal Mysqli query. This line of code (without connections and other things) is executed in 5ms. At the same time, when copying the same query to phpmyadmin, the query runs in 0.2ms even with the SQL_NO_CHACHE parameter. Tell me where to dig, because apart from this line there is nothing else.
mysqli::query("запрос");

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
Vitaly Karasik, 2020-05-19
@vitaly_il1

Enable slow query log with long_query_time = 0 - as far as I remember, this will save all queries with execution time on the database server.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question