Fermé

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!

Compétences : MySQL, PHP, Administration de Bases de données

en voir plus : 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

Concernant l'employeur :
( 51 commentaires ) Sydney, Australia

Nº du projet : #20891261

24 freelance font une offre moyenne de $157 pour ce travail

vili1977

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

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(419 Commentaires)
6.9
leemilun

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(66 Commentaires)
6.4
bindmission

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*

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(114 Commentaires)
6.0
susanna2018

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(16 Commentaires)
5.4
akweb2015

*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.

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(11 Commentaires)
5.1
CodeShood

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(19 Commentaires)
5.2
fastestJohn

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(25 Commentaires)
5.3
pinesucceed01

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(19 Commentaires)
4.9
hengzhulu

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(10 Commentaires)
5.0
TopDesigner315

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(20 Commentaires)
4.7
roadroll

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(17 Commentaires)
4.5
ahmedshabbirawan

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(9 Commentaires)
4.2
sreenivas2903

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(8 Commentaires)
3.7
techobrie

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(42 Commentaires)
5.1
aleksandr201906

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. Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(8 Commentaires)
3.7
volleyballstar

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(4 Commentaires)
2.9
alfredennis0325

~~~ 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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
2.1
finest2019

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(4 Commentaires)
2.0
shengui919

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.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
2.0
get4code

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(1 Évaluation)
1.0