Is there any solution for speeding up the login process when you have a large number of students?
Hi
All your initial pointers are in the introduction to the "Hardware and Performance" forum: https://moodle.org/mod/forum/view.php?id=596.
If the authentication is external, also see "Authentication" forum: https://moodle.org/mod/forum/view.php?id=42.
All your initial pointers are in the introduction to the "Hardware and Performance" forum: https://moodle.org/mod/forum/view.php?id=596.
If the authentication is external, also see "Authentication" forum: https://moodle.org/mod/forum/view.php?id=42.
How many is 'large number of students' ?
The number of students is nearing 1500.
How many is 'large number of students' ?
How are you doing authentication (logins) and enrolments (adding people to courses)?
When a user logs in, Moodle checks the login details then checks which courses they are enrolled on. This can take its time.
I do enrolments through an external MySQL database. Before, it took 10 seconds to check which courses a user is on in the database (we have 750,000 enrolments records). I optimised our database, and it now takes 0.2 seconds. Login time improved accordingly.
Hello Alex,
Thank you for your tip. We do also enrolments through an external MySQL database. The thing is I am not sure how I can optimise our database. Is there any general rule of thumbs? Can I have your advice if you't mind?
Sami
Alex, Thanks for the tip, I hadn't thought of setting up an external DB - I would be interested in your response to Sami's question as well...
Thanks so much for your assistance!
1500 is not that many at all.
So, what makes you think your performance problem is tied to the amount of users you have?
I think as Visvanath pointed out, you should try some general performance improvements.
The comments about an external enrolment DB are just that, they are for managing your enrolements and not your actual student data inside Moodle. Moodle won't be reading from it in the general course of operation, but will sync from it on a regular basis.
I understand... I was thinking it was tied to the user number because I have smaller moodle installs that work fine.
I will look into the general moodle and database optimizations mentioned above...
Thanks to all for the support