Find Jobs
Hire Freelancers

MySQL Query speed up

$15-25 USD / hour

Closed
Posted about 4 years ago

$15-25 USD / hour

I need to change the current query. too slow operation. JOIN operation is necessary.
Project ID: 24054907

About the project

37 proposals
Remote project
Active 4 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
37 freelancers are bidding on average $19 USD/hour for this job
User Avatar
Hi there, can you share some more details about your query? Can I see what query you are using right now? Look forward to hearing from you. Thank you, LEADconcept
$20 USD in 40 days
5.0 (60 reviews)
8.4
8.4
User Avatar
Hello, As an expert in SQL, i am very much interested to optimize your query to run faster. May i see the query please? Thanks
$20 USD in 40 days
5.0 (259 reviews)
7.8
7.8
User Avatar
Dear Sir,   Our team has a huge experience in Linux, SQL, MySQL, as a result, we can successfully complete this project. Having the required skills, we will be glad to help you.   We have 20 years of strong experience in outsourced web development, software development, managed services, and we provide 24/7 technical support. As well as we guarantee Canadian quality.   Please, review our profile to find detailed information about our company and our portfolio. Feel free to contact us and discuss all the details. Best regards, Sales department Tangram Canada Inc.
$21 USD in 5 days
4.9 (122 reviews)
7.7
7.7
User Avatar
Show me the query either it needs to be changed and also the code too in PHP. so show me the full operation of it and function too. i can fix it asap now. PHP/MYSQL expert here.
$25 USD in 40 days
5.0 (223 reviews)
7.4
7.4
User Avatar
Hi i can speed up MySQL Query i am expert at Linux , SQL , MySQL So send me Private message at PMB so we can discuss more about it Thanks
$15 USD in 40 days
4.8 (245 reviews)
7.7
7.7
User Avatar
Hello there, to improve the query first we need to use explain plan to see the cost of the slow query, and next we will see which one use full table scan, improper index and then change the join later Relevant Skills and Experience Database programming 10 years including tuning efforts
$20 USD in 20 days
5.0 (44 reviews)
5.7
5.7
User Avatar
I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.
$27 USD in 10 days
5.0 (54 reviews)
5.5
5.5
User Avatar
Hi. I have experience speeding up queries, one can usually achieve speed up using : - joins with order of conditions to match indices - aims new indices - reorder where conditions to match indices If you provide me with your table structure "show create table..." and the query to speed up, I can help. Also statistics about table size will be helpful.
$24 USD in 40 days
5.0 (5 reviews)
3.8
3.8
User Avatar
I am already working on mysql optimization project. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. I am also good for BI part like SSIS, SSRS and SSAS. I am ready to work any time zone. I can join immediately.
$16 USD in 40 days
5.0 (5 reviews)
3.4
3.4
User Avatar
**********AWS + RDS +S3 + Ec2 + Docker + Mysql + UBUNTU + Linux EXPERT*********** With 3 years of Experience Dear Employer, Hope all's well..!! Thanks for job posting. I have gone through your job description and found my skills best suited for this project and give you 100% assistance as Devops AWS + RDS +S3 + Ec2 + Docker + Linux EXPERT. Skills: Linux Operating Systems:-Ubuntu,CentOS,Redhat, And Servers Aws, S3,RDS,Mysql,Raspberry-pi3 And 4,Docker,Apache,Php,Phpmyadmin,Html,css,Troubleshooting (Hardware or software). ---Setuping up Our Own Commands ---Installation Any packages --- Azure cloud ---Binding And Bonding ---Shell-Scripting **** Automation Scripting **** ---Aws S3 mounting ---Mysql(Aws RDS) ---Docker ---Monitoring Scripts ---Setuping AWS Server, EC2 instance ,S3 bucket ---If one Server Get down Automatically On Another server by Script ---Sending Alert mails ---Cpu, Memory Alert to mail ---Cron-job Sheduling ---Raspberry Pi-3 and 4 ---Python ---ssh I am Sincerely looking forward to communicate with you as a person and I would really appreciate if you give us your valuable time. Let me know more detail about your Project via private message for better understanding. ping me Regards, Rehan Alan
$20 USD in 40 days
4.9 (18 reviews)
3.5
3.5
User Avatar
Hi, I am available to work on this project if you like you can discus with me in private message I start work asap.
$20 USD in 1 day
3.5 (13 reviews)
4.4
4.4
User Avatar
Having been doing this sort of optimization work every day for dozens of clients for the past 20 years, I'm reasonably sure I can fix that query for you in about a minute. If you are interested, I also do full system-wide performance analysis on a fixed price project basis. I have typically delivered overall performance improvements in the 10x to 50x range, but speed-ups of as much as 100,000x with individual queries are not uncommon. As a part of this, I can also deploy a performance monitoring system for you that would let you keep an eye for performance impacting issues as soon as they begin to manifest.
$15 USD in 20 days
5.0 (6 reviews)
3.1
3.1
User Avatar
I'll give you a lifetime support for all bugs that may appear because of our code I have a complete team of developers for mobile applications and website. We also do design for websites and logos We can do also motion graphic videos please contact me for more details
$15 USD in 40 days
5.0 (4 reviews)
3.1
3.1
User Avatar
Data scientist and verified SQL expert, certified in the top 3% of all freelancers globally. Have written complex queries powering multi million dollar businesses. Ready to work on this for you right away.
$22 USD in 40 days
5.0 (6 reviews)
3.3
3.3
User Avatar
I run exclusively on linux. I have been working on MySql as a freelancer for the last 4 years. I can write your queries for you, joins and all.
$20 USD in 20 days
5.0 (1 review)
2.8
2.8
User Avatar
Over the last 10 years, I provide web design as well as web development. I am completely committed not only to provide basic services, also doing everything possible to get your business growing explosively. My Top Skill-set: 1. Server Side Programming→ ASP.NET C# / MVC 3 & 4 / Signal R and all technologies related to .Net→Web API / Web Services → Dev Express Control→ Telerik Controls→ Payment Gateway Integration 2. Client Side Programming→ AngularJS / ReactJS / Jquery / JavaScript / Ajax 3. DataBase Skills→ SQL Server 2005 /2008/ 2014 R2→ MY SQL  4. Cloud Skills→aws appsync,lambda ,rds ,sns ,sqs,load balancer,dynamodb,node.js 
$20 USD in 40 days
5.0 (1 review)
2.7
2.7
User Avatar
Hi , Hope you are doing well. I am excited to work on this project.I read a description and i will complete the project in 2 hours. I am web developer and having 3 years of experience.  Expert: 1. Wordpress , PHP, C# , HTML ,Javascript, MYSQL - MSSQL. Please give me an opportunity. Thanks
$15 USD in 2 days
4.9 (6 reviews)
2.4
2.4
User Avatar
SKILLS JavaScript, jQuery, jQuery Mobile, CSS3, HTML5, Bootstrap 3, Linux, Apache, PHP, Git, XMPP, AWS, REST API, Codeigniter, Web Scraping EXPERIENCE Freelance Developer, ​ - Sr. PHP Programmer December 2014 - PRESENT ● Lead developer in the development of Open Source projects choosing a range of technologies like JavaScript, jQuery, HTML5, PHP, MySQL, Codeigniter and Git. ● Deployed & maintained many Web Applications in Amazon EC2, Linode and many popular Linux servers like GoDaddy, Hostgator, Bigrock and many more. ● Working with large mysql database and query optimization for insert, select, delete, update. ● Add many third party tools and API like Twitter Digits, Amazon S3, cloudflare, Twilio and many others in different project to increase my skill and meet requirement. ● Setup xmpp based chat server, And integrate developed some own algorithm for filesharing. And make chat client which communicate with mobile application like whatsapp web. 360
$20 USD in 4 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hello, I saw you need to optimize sql query, I have experience in this area, I can indexes for columns, make right joins to have the best time. We can discuss more details on chat. Thanks
$15 USD in 20 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I would be glad to optimize your SQL query to decrease the run time. I have over 20 years of SQL experience.
$25 USD in 40 days
0.0 (0 reviews)
2.8
2.8

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Feb 23, 2020

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.