Find Jobs
Hire Freelancers

Reduce MySQL query execution time to 1ms

$30-250 AUD

Closed
Posted over 4 years ago

$30-250 AUD

Paid on delivery
Hi there, I'm looking for an expert MySQL DBA (or equivalent) to reduce the execution time of my MySQL query to 1ms or less. I have attached the database schema of the relevant tables, the PHP code which generates the query, current table sizes and row counts, and a sample query. I can supply full table data to freelancers I speak with who are interested in the project and think they can achieve my target. Please note these very important parameters when considering bidding: 1) Current execution of the sample query in my environment with no load is 60-200ms, so I am looking for over a hundred-fold improvement. I won't accept a query that runs "faster" - it needs to run for 1ms or less 2) I am on a shared host (GoDaddy reseller) running MySQL 5.6. Please don't suggest moving hosting providers, VPS, MySQL upgrades or anything that involves the Linux shell or super-user/root access. None of these are possible. Your job is to optimise my query in my current environment 3) Further to the above, no MyQSL configuration changes are possible. I'm happy to supply you with whatever configuration parameters you need prior to you bidding, but they can't be changed 4) Changing my query, adding indices, changing column data formats and similar are all acceptable 5) What is not acceptable is anything that would fundamentally change my app logic (splitting tables etc.) Please let me know if you have any questions, otherwise happy bidding!
Project ID: 20891261

About the project

14 proposals
Remote project
Active 5 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
14 freelancers are bidding on average $151 AUD for this job
User Avatar
Hello Hope you are doing well. I have 7 years of experience in Linux and MySQL. I can reduce the MySQL query execution time. Regards VishnuLal*
$150 AUD in 1 day
4.9 (341 reviews)
7.0
7.0
User Avatar
Hello. I would like to help you with mysql query optimization. I have experience. Please read my feedbacks. Thanks.
$111 AUD in 1 day
4.9 (584 reviews)
7.1
7.1
User Avatar
Hello :) Thanks for your posting. I saw your description carefully. I am a web expert who have 8+ years of experiences. My skills are Html5,CSS,SCSS, Bootstrap,Javascript,Jquery,MySql,PHP especially MySQL is really my type ... I can implement your project with fully and completely. I can help you with my best. I hope that you contact with me. If you need, i will send my live link to you Thank you :)
$130 AUD in 2 days
4.9 (29 reviews)
5.3
5.3
User Avatar
Hello i have experience in mysql optimization and imho can help you, i'm open to discuss and ready to job.
$90 AUD in 2 days
5.0 (21 reviews)
4.7
4.7
User Avatar
Hi Sir please add the indexes on columns. Adds prepare keywords with remove joins. these all things i have use in Ali Express scraping data. Which brings results faster. Regards Ahmed Awan
$133 AUD in 2 days
5.0 (9 reviews)
4.3
4.3
User Avatar
i can work for jquery High Quality + Fast Speed = Excellent Result + Business Success, this is my working style. I have gone through your Job post and I can understand your job requirement thoroughly. I have a total of 15 years of experience in Web Designing and Development and had completed a number of projects with some great graphics and User Interface so far. I have all the required skills and experience you need for the above Job. I have strong command over: * WordPress, PHP, Wordpress themeing, Plugin Development * Android and IOS all kind of mobile apps development *Responsive theme Design * HTML5, CSS3 , Jquery, Bootsrtap, Git, * Widget Development * Other CMS: Magento, Joomla, Expression Engine, Drupal etc. * I’m honest & trustworthy, dependable & fast learner. * I’ve over 7 years experience in Wordpress Website designing/development. * I am available 40 hours a week for your job. You can be assured of a quality communication and the quality of the work provided from my end. I’m looking forward to hearing from you soon. Thank you for considering my cover letter.
$77 AUD in 7 days
3.4 (53 reviews)
5.2
5.2
User Avatar
Hii. I am expertise in aql queries i will fuldill ur need ping me if u are interested and also let me know total rows of the table
$166 AUD in 2 days
4.7 (8 reviews)
3.7
3.7
User Avatar
We've been working on different platforms, like CRM, Bootcamps and Customer Surveys, and all these platforms requires optimized / faster queries to handle concurrent users. We hope that we will be able to work with you and have a chance to scale and optimize your queries.
$300 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, looking at your project description, I think this is the best suited job for me as I have over 8 years of experience in Database Development along with Performance Tuning. I have worked on various Databases like Oracle, SQL server, PostgreSQL etc. I have done OCA certification in Database Development and Oracle 12c: Performance Tuning and Management certification. Expecting a call from you where we can discuss further and I can prove my knowledge for this job to you.
$140 AUD in 7 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
53
Payment method verified
Member since Mar 8, 2012

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.