Hello All,
Since upgrading to v 1.8.1 we have performance issues when viewing studnent details. This occurs where students are enrolled on a lot of courses (15 courses for example).
Moodle takes over a minute to display these records. By Comparison a student only enrolled on one or two courses will display almost instantaneously.
I was wondering if anyone else has observed this and whether anyone has looked at re-factoring the code used here?
Regards, Jeremy
I've noticed some performance improvements in this area on 1.8.2+ over 1.8.1. So, if a minor upgrade is an option for you, try going for the latest 1.8.2+. The delay is still there, but less so. Also, I've seen the performance double according to the database settings, but haven't had the chance to figure out what is wrong with the slower box (or right with the faster)...
Hi Samuli,
Can you tell me what database settings you were adjusting?
I played with database caching / number of cached threads etc. but these settings made no difference.
From what Martin says about code re-factoring I am not sure there is much that can be done regarding DB optimisation.
The issue is specific to users enrolled on a lot of courses, generally performance is not an issue.
Jeremy
Can you tell me what database settings you were adjusting?
I played with database caching / number of cached threads etc. but these settings made no difference.
From what Martin says about code re-factoring I am not sure there is much that can be done regarding DB optimisation.
The issue is specific to users enrolled on a lot of courses, generally performance is not an issue.
Jeremy
Unfortunately I can't help you there: I didn't adjust any settings, just observed that one box was running twice as fast as another, looking at a profile of a user with 35 courses. The slower box took 20 seconds, the faster took 10. Didn't have the time to figure out what setting was responsible for the difference 
It could just be that the MySQL 5.0 versions differed and one was faster than the other. Both had similar PHP setups and query cache on. Maybe some JOIN limits, or not. Just guessing at this point
It could just be that the MySQL 5.0 versions differed and one was faster than the other. Both had similar PHP setups and query cache on. Maybe some JOIN limits, or not. Just guessing at this point
Hi Jez, this bug and fix may help, we found that the function update_course_icon() has a big problem when viewing the site as a student.
http://tracker.moodle.org/browse/MDL-10635
http://tracker.moodle.org/browse/MDL-10635