MySQL Forums
Forum List  »  Spanish

Re: Error Code: 2013. Lost connection to MySQL server during query
Posted by: Jesús Uzcanga
Date: January 27, 2018 11:42PM

Ni siquiera me voy a tomar el tiempo de tratar de analizar tu horrible consulta... Con relacion a los 80 mil registros, Cuando haces sub'querys es como la pelicula de dicaprio Inception, se multiplican los valores por si mismos asi que con 3 sub'querys tu consulta estab intentando buscar entre 512000000000000 registros.

Aplica para 1 UPDATE (tiene que revisar los 80 mil) más 2 sub'querys (tiene que revisar los 80 mil registros en cada uno)



Aplicar filtro en estos cass no sirve de mucho, si bajas la cantidad total un poco pero no es mucho.

___________________________
Ing. Jesús Alfredo Uzcanga
Twitter: @JesusUzcanga

We learn the 20% of what we HEAR,
the 50% of what we SEE,
the 80% of what we DO and
the 95% of what we TEACH.

____________________________________________________________
https://www.linkedin.com/in/jauzcanga/

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Error Code: 2013. Lost connection to MySQL server during query
362
January 27, 2018 11:42PM


Sorry, you can't reply to this topic. It has been closed.

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.