MySql Select Query Optimization

Ολοκληρωμένο Αναρτήθηκε Πριν 2 μήνες Πληρώθηκε κατά την παράδοση
Ολοκληρωμένο Πληρώθηκε κατά την παράδοση

My project revolves around a MySQL select query that is showing slower-than-desired execution times. I cannot provide the data as it has PII and is very large. Main issue is that for pulling 1 month of data it takes about 3 hours, regardless if it returns 500 rows or 500,000 rows. There is likely a required index that I cannot see.

I will be providing

1) The query

2) The Explain Tree

3) The table definition from which it is pulling data.

MySQL Διαχείριση Βάσεων Δεδομένων Προγραμματισμός Βάσης Δεδομένων SQL

Ταυτότητα Εργασίας: #37858724

Σχετικά με την εργασία

41 προτάσεις Απομακρυσμένη εργασία Ενεργό Πριν 2 μήνες

Ανατέθηκε στον:

vinaysinghh

Hi. I am vinay having more then 14 yrs of experience in mysql database administration and performance tunning You can see my profile and see all the reviews on mysql performance projects that i have completed sucessfu Περισσότερα

$140 USD σε 7 μέρες
(65 Αξιολογήσεις)
5.5

41 freelancers κάνουν προσφορές κατά μέσο όρο $138 για αυτή τη δουλειά

coolguyinus2004

I need ftp and cpanel and the website link where this issue happening and phpmyadmin access to look and fix it for you. discuss with me more please. let me know.

$300 USD σε 7 μέρες
(233 Αξιολογήσεις)
7.5
abubakar12345678

I will optimize MySQL select query. Give me chance to show you good result. Thanks....................

$60 USD σε 1 μέρα
(52 Αξιολογήσεις)
5.4
AbdulBasitAli045

Dear Client. When it comes to your project, i am expert. I will provide you 100% satisfaction work and full service. It would be great if you hire me. Based on your feedback, I can draft my proposal accurately and Περισσότερα

$85 USD σε 2 μέρες
(95 Αξιολογήσεις)
5.7
ihtsham3

I'm ready to optimize your site Now & give you a 80+ Score on Google Page Speed, A+ Grade on GtMetrix with <2 seconds maximum loading time for permanent. I'm a professional Website optimizer and have more than 10+ yea Περισσότερα

$30 USD σε 1 μέρα
(12 Αξιολογήσεις)
4.3
idogoldblatt

With my significant experience in SQL and database management, I believe I'm the specialist you need to tackle your project. From designing complex databases to enhancing performance through optimized queries, my skill Περισσότερα

$160 USD σε 4 μέρες
(1 Κριτική)
4.1
Muhammadzeesha59

Hello Sir/MAM I am a skilled full stack developer. Having rich experience in Java , Python , C , C++ , C# , Eclipse , Sql , Mysql , .Net ,Oracle , Object Oriented Programming , Data Structure Περισσότερα

$40 USD σε 2 μέρες
(12 Αξιολογήσεις)
3.8
b2btechnology20

Hello, Hope you are great!! I am highly skilled in HTML, CSS, and Javascript. I have over 8+ years of experience with each of these technologies, and I am eager to learn even more technologies to sharpen my skillset. Περισσότερα

$140 USD σε 7 μέρες
(11 Αξιολογήσεις)
4.1
laraibfatima399

Hi There I have checked your project description and understand everything. I am very confident that i can handle this project perfectly. As i have 10+ years of experience in this field. Right now, I am placing a pl Περισσότερα

$250 USD σε 2 μέρες
(2 Αξιολογήσεις)
3.4
siedovyehorrr32

Hello I’ve carefully checked your requirements and really interested in MySql Select Query Optimization. I am confident for your project because I have skills of Database Administration, SQL, Database Programming and Περισσότερα

$150 USD σε 1 μέρα
(1 Κριτική)
2.6
souyah

Hi, there! Having confirmed the job posting, it seems like you might be looking for a senior developer for your project - MySql Select Query Optimization. I have worked with similar projects so that I can provide you Περισσότερα

$200 USD σε 4 μέρες
(2 Αξιολογήσεις)
2.6
mudassarsharif24

As an experienced full-stack developer and an expert in database administration & programming, I am confident in my skills to optimize your MySQL select query. At Techfusion, we believe that efficient data retrieval is Περισσότερα

$30 USD σε 7 μέρες
(1 Κριτική)
2.2
ajeshjanardanan

Hi, How are you doing? As a professional developer with expertise in SQL/MySQL and database administration, I eagerly anticipate the opportunity to complete this project for you. Please drop me a message to discuss the Περισσότερα

$140 USD σε 7 μέρες
(1 Κριτική)
2.2
RajeshKannnan

As an experienced MySQL developer, I understand the critical importance of optimizing database queries to improve performance and efficiency. Although I acknowledge the sensitivity and size of your dataset, I assure yo Περισσότερα

$140 USD σε 2 μέρες
(4 Αξιολογήσεις)
1.9
arsalanmac

Hello Joe J., I would like to grab this opportunity and will work till you get 100% satisfied with my work. I am an expert having 5 many years of experience on SQL, MySQL, Database Administration, Database Programmin Περισσότερα

$160 USD σε 7 μέρες
(2 Αξιολογήσεις)
1.0
robert964

Dear Client, Thank you for sharing the details of your project. I understand the importance of optimizing your MySQL select query for faster execution times. I am well-equipped to assist you with this challenge. With Περισσότερα

$140 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
VadymLes

❤️Hi Joe J.❤️ Thank you for considering my bid. I have carefully read your requirements and understand what want. This opportunity interests me because I have extensive experience and deep knowledge in this field, inc Περισσότερα

$135 USD σε 2 μέρες
(0 Αξιολογήσεις)
0.0
durgesh8527

Having worked extensively with MySQL and having a deep understanding of database administration and programming, optimizing slow-running queries is right up my alley. I can confidently say that I am the best fit for yo Περισσότερα

$140 USD σε 7 μέρες
(0 Αξιολογήσεις)
0.0
akira49

Hello, As a Senior Full stack developer, I have rich experience in optimizing MySQL queries for improved performance. With your provided query, Explain Tree, and table definition, I'll identify the bottleneck and reco Περισσότερα

$150 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0
mr310

Hello, I'm an IT expert with more than 20 years of experience in the IT industry . I'm Cisco Certified networking professional 300-100 and 300-115 and Linux Certified Professional lpi 101, 102,103 and red hat certified Περισσότερα

$100 USD σε 1 μέρα
(0 Αξιολογήσεις)
0.0
marina240

Hello there, I'm an expert in PHP/MySQL and I have over 8 years experience in software engineering. Let me know if you are interested in. Thanks

$140 USD σε 3 μέρες
(0 Αξιολογήσεις)
0.0