We have a site where generally everything runs fine. The server is fast, plenty of RAM etc.
However suddenly we've found that lessons within 1 particular course category are taking up to 30 seconds to load.
Other lessons in other courses within the only other category are fine.
There are only 6 lessons in the "rogue" course and only 30 lessons in the whole site.
I've looked through the Forum & there doesn't seem to be anything which refers to this particular problem (i.e. similar items loading at different speeds)
THe database is currently 13mgb and we are keeping all logs (by customer request)
For what it's worth here's the debug on one of the problem pages:
And here's one for a good page
There are only 10 current users for the "good" course quoted above.
My knowledge of MySQL and PHP is dangerous so I'm loth to leap in without advice.
If anyone has any ideas or would care to point me in the right direction I'd be very grateful