Reduce MySQL query execution time to 1ms

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!

Taidot: MySQL, PHP, Tietokannan hallinto

Näytä lisää: edit csv mysql query, asp mysql query, 2013 lost connection mysql query, improve mysql performance, mysql optimize like query, query processing in mysql, mysql select query taking long time to execute, how to check query performance in mysql, how to reduce query execution time in mysql, mysql write performance, mysql analyze query, php mysql insert date time, mysql query report, php mysql query table, mysql query record bash, mysql query csv file, write mysql query, est time mysql query examples, reduce mysql query time cgiperl, mysql query latest time distinct

Tietoa työnantajasta:
( 51 arvostelua ) Sydney, Australia

Projektin tunnus: #20891261

24 freelanceria on tarjonnut keskimäärin 157$ tähän työhön


Hello. I would like to help you with mysql query optimization. I have experience. Please read my feedbacks. Thanks.

$111 AUD 1 päivässä
(419 arvostelua)

Hi George, I have checked your attachement.(I have found one error in your "sample [login to view URL]".) I can complete your project using index, unique, foreign key, additional fields and trigger. But there is one condition; T Lisää

$250 AUD 2 päivässä
(66 arvostelua)

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 1 päivässä
(114 arvostelua)

hi!???????????????????? Dear , my Client! i am very pleasure the opportunity to discuss this job with you. i am a full time freelancer with skills and experience on mysql, mongodb, php and angular.js, vue.js, react.js Lisää

$140 AUD 7 päivässä
(16 arvostelua)

*Hello. Let's start! I can do your project perfectly in a short time. Maybe you need database specialist. I am a database manager having 5+ years of experience. Ready to start. Thanks.

$100 AUD 1 päivässä
(11 arvostelua)

Hello, I am Software Engineer since 2013, I have completed more than 50+ successful mobile apps of iOS and Android. I am an ambitious, hardworking and challenging with high technical skills. I have a technical team wh Lisää

$150 AUD 5 päivässä
(19 arvostelua)

Hello! I read your description carefully. I've always done my project as the fastest and highest quality. I think your project is best for me. The reason is that I am a Web development expert. If you want to check my s Lisää

$100 AUD 3 päivässä
(25 arvostelua)

Dear Hiring Manager, Over 8+ Years of experience in developing web applications using technologies like PHP, HTML, AJAX and JavaScript in diverse domains like Finance, Health, Ecommerce, Telecom, Education etc. Dexte Lisää

$140 AUD 7 päivässä
(19 arvostelua)

Hi sir. I am a senior DBA and i have 5+ years experience with Database Optimize. Once you check me you can hire me. I hope to work with you. Please contact me and let's discuss more details. Thanks.

$350 AUD 2 päivässä
(10 arvostelua)

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 Lisää

$130 AUD 2 päivässä
(20 arvostelua)

Hello i have experience in mysql optimization and imho can help you, i'm open to discuss and ready to job.

$90 AUD 2 päivässä
(17 arvostelua)

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 2 päivässä
(9 arvostelua)

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 2 päivässä
(8 arvostelua)

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 Lisää

$77 AUD 7 päivässä
(42 arvostelua)

Hello I'm senior full-stack web+mobile developer - 10+ years of experience reflected in my Upwork reviews. Located in Eastern Europe(Minsk, Belarus), available for full-time(no day job) and ready to start immediately. Lisää

$200 AUD 7 päivässä
(8 arvostelua)

Hello, there! I have thoroughly read your job post and I would like to apply for it. I have been working with MYSQL more than 5 years already and have extensive experience in Query optimizing. I'm also experienced in Lisää

$30 AUD 3 päivässä
(4 arvostelua)

~~~ Very interested to me! ~~~ Hi, dear! Feel contact me for these kinds of projects. I will provide you the best result on [login to view URL] give me 10 minutes of yours. I am waiting for your message to have a detail discus Lisää

$140 AUD 7 päivässä
(1 arvostelu)

Hello! Over the last 10 years, I have developed data-driven applications mostly for the web using advanced backend(Laravel, Zend, Cordigniter, Wordpress, Joomla) with PHP/MySQL/NodeJS and rich frontend HTML/CSS/JavaScr Lisää

$140 AUD 7 päivässä
(4 arvostelua)

Hi, Mysql Optimization is my main skill. I saw your database diagram and sql files and could find some problems. Please feel free to contact me. Kind regards.

$140 AUD 7 päivässä
(1 arvostelu)

i am mysql expert have 10 year experience. i will solve you issue by changing query and add index. ready to start now

$250 AUD 7 päivässä
(1 arvostelu)