Find Jobs
Hire Freelancers

MySQL to generate a report (Dokes opensource - elearning)

$30-250 USD

Completed
Posted over 11 years ago

$30-250 USD

Paid on delivery
Modify/Create report page to display the student exam result from Dokeos platform (Open Source e-learning system) [login to view URL] 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.
Project ID: 4097788

About the project

10 proposals
Remote project
Active 11 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
We are interested let us discuss more abt this work. SAM
$160 USD in 12 days
4.8 (154 reviews)
7.1
7.1
10 freelancers are bidding on average $112 USD for this job
User Avatar
Please check PMB for portfolio and other details. regards.
$100 USD in 3 days
5.0 (164 reviews)
7.0
7.0
User Avatar
I'm ready.....
$84 USD in 2 days
5.0 (43 reviews)
6.1
6.1
User Avatar
------ 2YEARS EXPERIENCED PHP, MySQL, WORDPRESS, HTML, CSS & WEB DEVELOPING EXPERT ------
$100 USD in 5 days
4.8 (43 reviews)
6.0
6.0
User Avatar
Hi, I'm british, in the UK and available immediately, I've been a Mysql PHP expert for 15 years now, and my work is across the web in open source project from Drupal to phpMyAdmin. I'm an expert in tuning all the way down to the bare metal server level, the last job had a website taking up to 1 minute 30 seconds to display a page and I got it down to 8 seconds and less on a server running 200 website and I can provide their email as a reference. I've Pm'd you as every application is personal as is the level of service I provide. Philip
$130 USD in 1 day
5.0 (4 reviews)
4.8
4.8
User Avatar
Need more detail,can we discuss this,for more detail,check PM.
$190 USD in 8 days
2.5 (38 reviews)
6.8
6.8
User Avatar
i can do your job. please provide details.
$150 USD in 8 days
0.0 (1 review)
0.0
0.0
User Avatar
Please open your chat session for more discuss.I would like to work on this. Waiting for your response.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I have worked to clean up and improve many similar queries in the past. Would be happy to help you out on your project. Thank you.
$145 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Let's talk on instant chat to discus more in detail regarding the project.
$30 USD in 2 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of SINGAPORE
Singapore, Singapore
5.0
2
Member since Jan 5, 2013

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.