MySQL to generate a report (Dokes opensource - elearning)

This project was awarded to ernestbposl for $160 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

Modify/Create report page to display the student exam result from Dokeos platform (Open Source e-learning system)
[url removed, login to view]

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.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online