Hi there;
I am in the process of setting up our Moodle 2.6 install to use an External MSSQL database for enrolments. I have set up the scripts on my School Management Information System to pull the enrolment data and course data which is held there into a new database with a table for each, and I now need to set up the indexes on these tables.
The Moodle docs page here: admin/setting/enrolsettingsdatabase states "If the table is large it is a good idea to make sure appropriate indexes have been created:" but there is no indication of what the "appropriate indexes" might be!
I am assuming that it would be wise to index the user ID field in the database; but are there any other indexes I should create and are there any over performance optimisation tweaks that I could look at it streamline the external enrolment database access speeds?
Thanks,
Jon