How to avoid this very heavy query that slows down the application?
- by Juan Paredes
Hi,
We have a web application running in a production enviroment and at some point the client complained about how slow the application got.
When we checked what was going on with the application and the database we discover this "precious" query that was being executed by several users at the same time (thus inflicting an extremely high load on…