Group by, Order by and Count MySQL performance – Phpmyadmin
I have the next query to get the 15 most sold plates in a place: This query is taking 12 seconds to execute over 100,000 rows. I think this execution takes too long, so I am searching a way to…