This is probably the answer, if I do not think the question is broad or unclear: https://answall.com/q/32052/101, https://answall.com/q/55118/101, https://answall.com/q/35088/101, https://answall.com/q/23348/101.
>https://www.isbrasil.info/blog/comormedir-as-consultas-do-seu-mysql-e-evitar-lentidao.html. In this link you can see several tests that you can perform in your db, good luck. =)
@J.Augustolima this there is more about bank structure than the question of queries (consultations), the case of the author I think is more for querys even, of course the link is useful, after all it is useless to want to solve everything in the query and not to have a well planned structure of its tables and even settings in my.ini and server.
Just as a reference, in English, I haven’t translated yet: Identifying Mysql Slow Queries
– Tony
This is probably the answer, if I do not think the question is broad or unclear: https://answall.com/q/32052/101, https://answall.com/q/55118/101, https://answall.com/q/35088/101, https://answall.com/q/23348/101.
– Maniero
>https://www.isbrasil.info/blog/comormedir-as-consultas-do-seu-mysql-e-evitar-lentidao.html. In this link you can see several tests that you can perform in your db, good luck. =)
– J. Augusto Lima
@J.Augustolima this there is more about bank structure than the question of queries (consultations), the case of the author I think is more for querys even, of course the link is useful, after all it is useless to want to solve everything in the query and not to have a well planned structure of its tables and even settings in my.ini and server.
– Guilherme Nascimento