MySQL to generate a report (Dokes opensource - elearning)

IN PROGRESS
Bids
13
Avg Bid (USD)
$136
Project Budget (USD)
$30 - $250

Project Description:
Modify/Create report page to display the student exam result from Dokeos platform (Open Source e-learning system)
www.dokeos.com

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.

Skills required:
MySQL, PHP
Hire triporn
Project posted by:
triporn Singapore
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 150
in 2 days
$ 160
in 12 days
$ 100
in 3 days
$ 190
in 8 days
$ 100
in 5 days
$ 130
in 1 days
$ 84
in 2 days
$ 300
in 7 days
$ 150
in 8 days
Hire aristorinjuang
$ 199
in 3 days