Modify/Create report page to display the student exam result from Dokeos platform (Open Source e-learning system)
We have 4 e-leaning program that each program will had 5 - 10 modules.
Each training program will use 4 Tables in the database that related to display the report:
1. Student information
2. Student exam score
3. Exam module
4. Attempted of the exam
Current report is a simple SQL command and no issue when the database size is small (ex. 4MB); When click generate the report it will show immediately.
As of now we had too many subscribe user which increase the records (aprx. 20K record for each modules) and total database become 85MB.
It take about 15 - 20 mins to generate the report.
I am looking for the freelancer who expert in MySQL/PHP to either modify the current SQL command or create the new one to display report faster.