Find Jobs
Hire Freelancers

MYSQL QUERY OPTIMISATION! QUERY RUN TIME EXCESSIVE

$10-30 USD

クローズ
投稿日: 2か月前

$10-30 USD

完了時にお支払い
I have a mysql query which loads customers email addresses thru a php script. inside the php script it loads all customer email and usually only takes about 5 seconds then also in the script it loads any emails which have been BLOCKED or BLACKLISTED these come from another table then it allows me to filter the emails and remove the blocked emails from the mailing list before sending emails. BUT HERES THE MAJOR PROBLEM as my blacklist or blocked list grows the query time seems to GROW EXPONENTIALLY ive went from 5 secs with 0 blocked emails to 70 secs with just 300 blocked emails its taking around 5 secs for every additional email i add i had a look at the query it doesnt seem excessive but something is slowing it down i need this looked at to see if we can come up with a way to speed it up. 0 blocked emails page loads in about 5 secs 300 blocked emails page takes over 1 minute to load My MySQL query, which joins multiple tables, is taking too long to run. Unfortunately, I can't share the data it's run against. - The problem: My query takes too long to execute. I need it to run faster without compromising the results. - Query complexity: It involves joins across several tables. An understanding of structuring multi-table queries for optimal performance is needed. - Note: I won't be able to provide a sample data set. However, I can explain the schema in detail. I'm looking for someone with proven experience in MySQL query optimization, a deep understanding of databases management and performance tuning.
プロジェクト ID: 37855088

プロジェクトについて

40個の提案
リモートプロジェクト
アクティブ 1か月前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
この仕事に40人のフリーランサーが、平均$31 USDで入札しています
ユーザーアバター
It seems that your database is missing proper full text indexes i can help you improve the query and make it fast lets discuss the details over chat
$30 USD 7日以内
4.9 (66 レビュー)
8.1
8.1
ユーザーアバター
Hi There Hope you are doing good I have worked on many query optimization project. I will review the code for efficient join of table, indexes, etc. Available to discuss now Regards
$20 USD 7日以内
4.9 (640 レビュー)
7.3
7.3
ユーザーアバター
Hi, i will optimize mysql query. I am Wordpress,PHP programmer having 10 years of experience. I am very good in wordpress,php,mysql,joomla.
$60 USD 2日以内
4.8 (576 レビュー)
7.4
7.4
ユーザーアバター
Hello. I read your requirement i will do that. Please come on chat we will discuss more about this. I will waiting your reply.
$30 USD 1日以内
5.0 (53 レビュー)
5.6
5.6
ユーザーアバター
I will properly optimize all your query right now to perform all operations quickly. I'm looking forward to working with you!
$100 USD 1日以内
4.8 (62 レビュー)
5.9
5.9
ユーザーアバター
" MYSQL QUERY OPTIMISATION! QUERY RUN TIME EXCESSIVE" sir i read your project brief and I will do your project Please review my similar portfolio https://www.freelancer.com/u/Programmers12 My Experience in this field for last 10 years and i m very consistent in my work i work almost 20 hours a day i am highly professional and master in Web designing and developing field and i will do a great job on your project if you give me the chance and will make you 100% satisfy from my work . Please come to chat for discuss in details. I'm ready to start your project now. Muhammad A
$20 USD 1日以内
5.0 (18 レビュー)
5.3
5.3
ユーザーアバター
Hello there. I have more than 20 years of experience in web programming (PHP, MySQL, HTML, CSS, Javascript). I can solve your problem by optimizing your SQL query and, if necessary, I can also optimize your MySQL tables so you don't have the problem again. Thanks, Federico
$25 USD 1日以内
5.0 (20 レビュー)
5.0
5.0
ユーザーアバター
Hey! It is good that my skills match your project. I have 9+ years of experience as a web developer. My skills include PHP, WordPress, HTML, HTML5, CSS, Web Design, JavaScript, Laravel, Bootstrap, MySQL, Woocommerce, Cake Php, CodeIgniter, Magento, Adobe Photoshop, Adobe Illustrator, CorelDRAW, Bootstrap, Angular, Javascript, jQuery, and My SQL. Let's chat figure out your project, and make it awesome together. I look forward to your response Thanks and regards, Atif Y
$20 USD 1日以内
4.9 (49 レビュー)
5.0
5.0
ユーザーアバター
Hi there.. I'm a personal freelancer and interested in joining your project.. I've read your project description also.. so hopefully could help you to optimize and provide some SQL / query table from joining multiple table database to retrieving email data as your expected.. and now I'm ready and available.. so I can do it soon..so will give it to you in the next few hours.. Looking forward to discussing and collaborating with you! Thank you Vincent
$20 USD 2日以内
4.7 (42 レビュー)
5.3
5.3
ユーザーアバター
Dear Client, I understand the importance of speeding up your MySQL query to improve performance. As an experienced MySQL developer, I specialize in query optimization and database performance tuning. I have successfully optimized complex queries in the past, improving execution times while maintaining data integrity. I will carefully analyze your query and database schema to identify potential bottlenecks and inefficiencies. Using advanced optimization techniques, I will propose and implement solutions to enhance the query performance without compromising accuracy. With my expertise in MySQL optimization, I am confident that I can help you achieve significant improvements in query execution time. Let's discuss further details so I can begin optimizing your query promptly. Regards, Sumit Joshi
$24.99 USD 7日以内
5.0 (14 レビュー)
4.5
4.5
ユーザーアバター
Yea I could probably optimise it for you, providing there isn’t something else at play like you db server (luckily I have experience there as well) - bit hard to tell without seeing the query and database structure first though! I have immediate availability
$30 USD 1日以内
5.0 (20 レビュー)
4.5
4.5
ユーザーアバター
You have problems with query optimization. , I can start immediately on this project I have few questions about the requirement. Can we discuss this over chat? Looking forward to hearing from you soon. Best regards,
$30 USD 7日以内
5.0 (19 レビュー)
4.1
4.1
ユーザーアバター
Dear Client, I can create some Advance SQL queries for you that will reduce the overall runtime of your PHP script. Furthermore, I am a web developer I can also look at your PHP script and check its logic as well. I am a web developer having 5 years of experience in customized web development. Let me know if you are interested and i can start right away Looking forward to working with you Regards, Jehanzaib K.
$15 USD 1日以内
5.0 (11 レビュー)
4.2
4.2
ユーザーアバター
Hi, I understand you're facing a performance bottleneck with your current MySQL query used to filter customer emails for email campaigns. The query time seems to be increasing exponentially as the number of blocked emails grows. I possess extensive experience in MySQL query optimization and database performance tuning. I am familiar with various optimization techniques and can leverage them to improve your query's efficiency. I am confident that with my expertise, we can significantly improve the performance of your query and ensure efficient email campaign management. Best Regards, Raj H
$20 USD 7日以内
4.1 (12 レビュー)
4.3
4.3
ユーザーアバター
Hi, We specialize in MySQL query optimization and performance tuning. With our expertise, we'll analyze your query and implement optimizations to significantly reduce execution time while maintaining accuracy. Let's Start!
$49 USD 1日以内
5.0 (9 レビュー)
3.5
3.5
ユーザーアバター
As an experienced Full Stack Developer, I have spent countless hours fine-tuning and optimizing countless MySQL queries, with significant improvements in their runtime. I understand that the culprit for slower query execution isn't always immediately obvious—I have learned to wear a detective’s hat and investigate for the root cause, even when confronted with seemingly inexplicable performance issues. My expertise in Content Management Systems (CMS), particularly Shopify and WordPress, has given me an insightful understanding of database management and performance tuning on a granular level. I’m confident this expertise can be successfully leveraged to identify the inefficiency in your multi-table query and apply necessary optimizations. Finally—and perhaps most importantly—I am passionate about providing quick yet thorough solutions to clients’ problems while prioritizing user experience within those solutions. I pride myself on being able to take on new challenges and deliver distinctive results. Let us work together to identify the bottleneck slowing down your query execution and implement solutions that will bring those run-time numbers back down to a minimum.
$50 USD 7日以内
5.0 (4 レビュー)
3.3
3.3
ユーザーアバター
Hello, I'm Dinesh Kumawat, and I'm committed to delivering high-quality work that guarantees 100% satisfaction. Your success is my priority, and I understand that the quality of my work directly impacts your achievements. I aim to build long-term client relationships based on trust and excellence. My expertise extends to various domains, including web and app development, and I offer a wide range of services to clients globally. Here's an overview of my skills: Web & App Development: JavaScript PHP MySQL WordPress Magento CodeIgniter Shopify .NET Flutter Development FoxPro I possess in-depth knowledge of all frameworks and software design and development methodologies. This extensive skill set allows me to cater to diverse project requirements and deliver tailored solutions. My commitment to you is that your project will be completed on time and within budget, with no surprises along the way. I am dedicated to ensuring 100% client satisfaction, and my ultimate goal is to establish long-lasting relationships with clients like you. If you're seeking a reliable partner for your web and app development, Shopify, .NET, Flutter development, FoxPro, or third-party API integration needs, I'm here to serve you. Let's collaborate to achieve your goals and exceed your expectations. Thank you for considering my services, and I look forward to the opportunity to work with you. Best regards, Dinesh Kumawat
$30 USD 7日以内
5.0 (4 レビュー)
2.9
2.9
ユーザーアバター
Hi there, I will help you fix this. There will be different techniques to solve this. Not just optimising the query, but table indexing, normalisation etc. I will make this work for you. Let me know more details Thanks Bhagya
$30 USD 1日以内
4.8 (1 レビュー)
2.5
2.5
ユーザーアバター
As an experienced full-stack developer with over 8 years under my belt, including in-depth knowledge of MySQL query optimization, I am eminently qualified to tackle your query issue. My expertise extends far beyond the parameters of HTML, JavaScript, PHP, and more - I also possess end-to-end understanding in data-driven architecture as a result of managing high-stakes projects. My prior hands-on experience includes building dynamic systems like ecommerce web apps and health care solutions - where performance and scalability are paramount. My approach is always rooted in meticulous analysis and strategizing to ensure optimal results. I'll deploy my dexterity with React, Angular, Nest, Node, MongoDB - and my fluency in SQL - to restructure your query - balancing efficiency and accuracy. In past engagements such as creating a react wrapper for the pro version of dhtmlx Library or building a Project Management tool rewriting API calls from Jira, I've scrutinized performance to the finest detail – exactly what your project needs! Let's work together on this project and open up a whole new world of efficiency for your database queries!
$20 USD 7日以内
3.2 (3 レビュー)
2.0
2.0
ユーザーアバター
***SUCCESSFUL DELIVERY & CLIENT SATISFACTION*** I am Results Oriented Full Stack PHP, Laravel, ReactJs, Node Js, React Native, MERN Stack, LAMP Stack and Hybrid Mobile Apps Engineer. I have 10+ years of Experience in building Large Scale Applications and Hands on experience in Delivering 100% successful projects including the visibility in all the phases of Software Development Life Cycle in E-Commerce Applications, B2B, B2C, FinTech, Digital Payments, 3rd Party Integration, Health Care, Driving and Delivery Apps, Custom Web Applications and some industrial CMS like Magento, WordPress and Shopify. Key Skills: Web Designing - Graphic Design - UI / UX - Web Development - Mobile Applications - PHP - Laravel - WordPress - WooCommerce - Magento - Shopify - React JS - React Native - Flutter - Node JS Tech Stack: HTML - CSS - Bootstrap - React Js - Vue Js - Alpine Js - Tailwind React Native - Android Development - IOS - FlutterNode JS - Nuxt - Redux - React - Nest - JS - Angular JS PHP - Laravel - CodeIgniter - Livewire WordPress - WooCommerce - Magento - Shopify MySQL - Postgres - Mongo DB - NoSQL - Dynamo DB Cloud Solutions - Amazone Web Services (AWS) GitHub - BitBucket - SVN Jira - Azure - Slack - Trello Let's connect to achieve your goals together. ***Kindly Discuss & Lock The Requirements Before HIRE ME*** ***Client Satisfaction is My End Goal***
$20 USD 7日以内
5.0 (5 レビュー)
1.4
1.4

クライアントについて

UNITED KINGDOMのフラグ
Clydebank, United Kingdom
4.9
28
お支払い方法確認済み
メンバー登録日:8月 17, 2010

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。