Find Jobs
Hire Freelancers

Reduce MySQL query execution time to 1ms

$30-250 AUD

已关闭
已发布超过 4 年前

$30-250 AUD

货到付款
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!
项目 ID: 20891261

关于此项目

14提案
远程项目
活跃5 年前

想赚点钱吗?

在Freelancer上竞价的好处

设定您的预算和时间范围
为您的工作获得报酬
简要概述您的提案
免费注册和竞标工作
14威客以平均价$151 AUD来参与此工作竞价
用户头像
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天之内
4.9 (341条评论)
7.0
7.0
用户头像
Hello. I would like to help you with mysql query optimization. I have experience. Please read my feedbacks. Thanks.
$111 AUD 在1天之内
4.9 (584条评论)
7.1
7.1
用户头像
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 在2天之内
4.9 (29条评论)
5.3
5.3
用户头像
Hello i have experience in mysql optimization and imho can help you, i'm open to discuss and ready to job.
$90 AUD 在2天之内
5.0 (21条评论)
4.7
4.7
用户头像
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天之内
5.0 (9条评论)
4.3
4.3
用户头像
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 在7天之内
3.4 (53条评论)
5.2
5.2
用户头像
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天之内
4.7 (8条评论)
3.7
3.7
用户头像
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 在2天之内
0.0 (0条评论)
0.0
0.0
用户头像
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 在7天之内
0.0 (0条评论)
0.0
0.0

关于客户

AUSTRALIA的国旗
Sydney, Australia
5.0
53
付款方式已验证
会员自3月 8, 2012起

客户认证

谢谢!我们已通过电子邮件向您发送了索取免费积分的链接。
发送电子邮件时出现问题。请再试一次。
已注册用户 发布工作总数
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
加载预览
授予地理位置权限。
您的登录会话已过期而且您已经登出,请再次登录。