Slow Login With Large number of students

Slow Login With Large number of students

David Korff發表於
Number of replies: 8

Is there any solution for speeding up the login process when you have a large number of students?

 

評比平均分數: -
In reply to David Korff

Re: Slow Login With Large number of students

Simon Story發表於

How many is 'large number of students' ?

In reply to Simon Story

Re: Slow Login With Large number of students

David Korff發表於
The number of students is nearing 1500.
 
 
 
Picture of Simon Story
Re: Slow Login With Large number of students
by Simon Story - Tuesday, 5 February 2013, 6:21 PM
 

How many is 'large number of students' ?

In reply to David Korff

Re: Slow Login With Large number of students

Alex Walker發表於

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.

In reply to Alex Walker

Re: Slow Login With Large number of students

Sami Hwang發表於

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

In reply to Alex Walker

Re: Slow Login With Large number of students

David Korff發表於

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!

In reply to David Korff

Re: Slow Login With Large number of students

Simon Story發表於

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.

http://docs.moodle.org/23/en/External_database_enrolment

In reply to Simon Story

Re: Slow Login With Large number of students

David Korff發表於

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