Why is mysql query taking a long time to complete?

A

Alexey Alyushenko2015-10-10 23:06:07

PHP

Alexey Alyushenko, 2015-10-10 23:06:07

Hello, I'm new to building databases and querying them?
I wrote such a request, but it takes a very long time (15 sec), please explain why it takes so long to complete?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

C

Curly Brace, 2015-10-10
@stasuss

nested selects are not very productive ...
if I'm not mistaken, then on each such select a temporary table is created in memory, filled with results, and then the parent query passes through it. after which she is released.