Continuing the discussion from Slow sql queries:
The main reasons I ask are:
- I know some queries are slow for me
- my users are reporting slow page load times on mobile.
I know that mobile is generally slower because of the known android issue - so I’m thinking improving query times where they are obviously slow will help. In addition improve the users perception of performance.
###What’s the best way of reporting slow queries?
One big “Slow sql queries” topic I think is probably not best.
It would be nice to see something to log slow queries and automatically run an
explain checking CPU / memory? - with text easy to grab and post on meta to try and help improve reporting of these. Perhaps highlighting them if they are more than expected.
Perhaps set performance expectations for query results on a per query basis - expected 40ms, max 100ms - log automatically if outside of this range?
This could be a good early indication to some admins that there is an issue with the forum / site / server.