Optimize and diagnose MySQL slow queries including adding indexes, re-writing queries and adjusting code logic to optimize efficiency
$8-15 USD (1시간 기준)
I need someone who is experienced in MySQL specifically advanced optimization with many complicated queries using multiple joins, wheres, and etc.
This person should know best practices to maximize efficiency when it comes to indexes and how to write optimal queries. (example which of "not in", "left join", and "not exists" is the optimal query type to maximize speed).
This person should also be able to look at my code and suggest re-writes to increase code optimization in combination with MySQL optimization so that the code + mysql work as quickly as possible together to achieve fastest response times.
Code is PHP and some NodeJS
MySQL 5.6
Experience with Redis in combination with PHP and NodeJS is a plus, if you have this experience please note that in your bid.
프로젝트 ID: #16464417
프로젝트 소개
이 일자리에 대한 프리랜서 14 명의 평균 입찰가: $11 (1시간 기준)
I am a professional web designer and developer. Experience in with HTML, CSS, JS, jQuery, PHP, Laravel,MySQL. Very familiar with WordPress , MAgento , wooCommerce , Bootstrap ,Plugins ,API's and its customization. 기타
hello sir, I have great knowledge in core development and more than 4 year experience . thanks
i am mysql dba having more then 8 yrs of exp..............i am expert in optimization database on server level and also query level..........................................
Hello, Database normalization is a task for someone experienced with huge databases and it is something not very usual, unless if you work in industries as banks and engineering. I have the experience that you need 기타