Am helping to set up a new Moodle install with a large user base. Was wondering if people had any ideas on removing or reducing the performance impact of old user data - user records and other user data.
This post here refers to Moodle 1.6 but I think describes the current situation even in Moodle 1.9. There is no safe way to delete user records and associated data because there may be places that refer to these records.
I heard that the OU db some time ago had stabilized at over 450,000 users and as the Moodle db is indexed is coping OK.
Does anyone have any tips on coping with large ammounts of user data?
I guess one safe way of getting rid of old unwanted data is to have seperate courses for each year and then Moodle will be able to backup old courses and you can delete all course data when necessary. For a site with a lot of users the user db will get very large over the years but perhaps is manageable, at least until this problem is hopefully further addressed in future versions of Moodle.