Find Jobs
Hire Freelancers

Optimize MySQL query or index the database to optimize

$30-250 USD

Lezárt
Kiadva ekkor: 10 hónappal ezelőtt

$30-250 USD

Teljesítéskor fizetve
I am looking for a skilled database developer who can optimize my MySQL query or index the database to improve performance. The database is currently 1.3GB in size and is used for transactional processing. There are specific tables and queries causing performance issues that need to be addressed. The specific table is approx 200k rows. The query is fairly simple but taking 10 seconds to complete, and it needs to be closer to 1 second. I can provide the exact table structure and the query, but not actual data. The database is hosted on a normal windows machine. Ideal skills and experience for this project include: - Advanced knowledge of MySQL database optimization and indexing - Experience working with large databases - Ability to identify and troubleshoot specific tables and queries causing performance issues - Strong understanding of transactional processing If you have the necessary skills and experience, please submit a proposal detailing your approach to optimizing the database and estimated timeline for completion of the project.
Projektazonosító: 36690414

A projektről

63 ajánlat
Távolról teljesíthető projekt
Aktiválva: 9 hónappal ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
63 szabadúszó adott átlagosan $159 USD összegű árajánlatot erre a munkára
Felhasználó avatár
Hello, I am Raja Ahmad Noor, a highly skilled and experienced database developer with over 8 years of experience in optimizing MySQL databases for performance. Based on your project requirements, I believe I possess the necessary skills and experience to help you optimize the database and improve performance. Having worked on numerous projects ranging from small-scale databases to large-scale systems, I bring a deep understanding of different SQL queries and indexing approaches to the table. I will first analyze your query and run profiling to identify problem areas. After finding out the root cause of the problem, I will optimize your query by indexing the appropriate table columns. My approach is to first understand your business requirements and then provide a tailored solution that meets your needs. I am highly flexible and always strive to build long-term relationships by providing top-notch support and delivering the highest quality work. As you mentioned, you have some technical questions about the project, I would like to discuss these in detail before quoting the exact price and timeline. I am confident that once the details are ironed out, we can execute the project to your satisfaction. Thank you for considering my proposal.
$225 USD 10 napon belül
5,0 (307 értékelés)
8,7
8,7
Felhasználó avatár
I'm ready to optimize your site Now & give you a 80+ Score on Google Page Speed, A+ Grade on Google insight with <2 seconds maximum loading time for permanent. I'm a professional Website optimizer and have more than 10+ years of experience in it. I will do this project in 6hrs. I optimized almost 800+ websites and gave my clients 100% satisfaction. You can also check my previous optimization Portfolios & Reviews:-https://www.freelancer.com/u/nabeelawais83 Looking forward to working with You! Thanks Nabeel
$90 USD 1 napon belül
5,0 (380 értékelés)
7,9
7,9
Felhasználó avatár
Hello ,I am highly capable to Optimize MySQL queries or index database to optimize. I am a Passionate MySQL /PHP/Full stack developer with rich experience with many successful Tasks. Please ping me to get started and provide you great results. Thanks
$250 USD 3 napon belül
4,9 (110 értékelés)
7,9
7,9
Felhasználó avatár
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$180 USD 5 napon belül
4,9 (156 értékelés)
7,4
7,4
Felhasználó avatár
I have a few questions regarding the specifications that you have provided. Could we please have a chat? My Skills: SQL, Database Administration, MySQL, Database Programming and PHP
$30 USD 10 napon belül
4,7 (163 értékelés)
7,1
7,1
Felhasználó avatár
** I am a Full Stack developer and available for quick discussion ** Hello Greetings of the Day!! Yes, I will surely optimize the MySQL query or index the database to improve performance I will perform the following tasks perfectly . I am ready to get started immediately I have full time and required skills to carry out your project with high quality in time. >. My expertise: UI/UX design/development Frontend development Backend development Database development API Integration/development CMS/CRM development E-Commerce development Server development Flutter/React native app development SEO/Digital Marketing Expert AI/ChatGPT >. Please have a look at my profile: https://www.freelancer.com/u/Rekhathakur Thanks for taking the time to consider my proposal. Let's chat soon! Rekha Thakur Note: The budget will be quoted after the discussion.
$250 USD 7 napon belül
4,4 (85 értékelés)
7,5
7,5
Felhasználó avatár
Hi there, I am the best here! Please check out my profile and see what others have to say about the work I've done related to the skills you're looking for. Hope to work together soon. Thanks!
$222 USD 2 napon belül
5,0 (39 értékelés)
6,7
6,7
Felhasználó avatár
Hi!, I will do changes Optimize MySQL query or index the database to optimize. I can start the job immediately. I am an experienced WordPress Expert, Website Developer having more than 4 years of working experience in MySQL, Database Administration, SQL, Database Programming and PHP. Please get in touch to let me the requirements in more detail so that I can assist you in a better way and make your project run successfully. Regards, Mohammad Farhan Atif
$250 USD 4294967295 napon belül
4,9 (157 értékelés)
6,7
6,7
Felhasználó avatár
Hello Dear, I have read and checked your Project details, I have 8+ Years Of Professional Experience in Database Development and Designing. I will optimize your MySQL DB Query as per your needs and requirements. Lets have a quick chat to discuss details. I will show you my Portfolio as well in Personally. What benefits you will get from me?? -Highly quality and professional work - on time delivery - 24 hours support - communicate on time - give you technical support as well after completion - reasonable cost according to requirements Thanks, Waqas
$150 USD 3 napon belül
4,9 (125 értékelés)
6,8
6,8
Felhasználó avatár
Hi there! I am a senior software developer experienced in Bubble io. I have the necessary skills and experience to help you optimize your MySQL database and reduce its size by 200k rows. I would be thrilled to work on your project. I understand your need for improved performance and ability to identify and troubleshoot specific tables and queries causing performance issues. With my expertise in database optimization and indexing, I am confident that I can provide the necessary solutions to make your database faster than ever before. I would love to discuss further how I could best help you with your project. Please don't hesitate to reach out if you have any questions or would like more information about my skillset or previous projects.
$140 USD 7 napon belül
4,8 (38 értékelés)
6,5
6,5
Felhasználó avatár
Hello i am an expert in optimizing database . i can reach up to your specific tables and can fix the queries causing performance issues. i will try to make it closer to 1 second. please provide the exact table structure and the query so that i can review it and than can come back to you if required any other information thanks Furqan
$350 USD 7 napon belül
5,0 (16 értékelés)
6,1
6,1
Felhasználó avatár
Hello, my name is Baber and I am a professional mobile developer with extensive experience in software development. I understand that you are looking for a skilled database developer who can optimize your MySQL query or index the database to improve performance. I have the necessary skills and experience to complete this project. My expertise includes advanced knowledge of MySQL database optimization and indexing, as well as experience working with large databases. Additionally, I have the ability to identify and troubleshoot specific tables and queries causing performance issues. With my expertise, you can count on me to provide excellent results within the agreed timeline at an affordable cost. If you would like me to submit a proposal detailing my approach to optimizing the database and estimated timeline for completion of the project please let me know. Thank you for considering my bid!
$140 USD 7 napon belül
5,0 (57 értékelés)
6,1
6,1
Felhasználó avatár
I understand you are looking for a skilled database developer who can optimize your MySQL query or index the database to improve performance. My name is Navjot and I have 7+ years of experience in Web Design & Development. I have the necessary skills and experience to complete this project. Specifically, I have advanced knowledge of MySQL database optimization and indexing as well as experience working with large databases. Additionally, I have the ability to identify and troubleshoot specific tables and queries causing performance issues. I would be delighted to help you optimize your database and get it closer to 1 second for the specific query. Please feel free to send me any additional information or queries regarding this project; I look forward to hearing from you soon!
$140 USD 7 napon belül
4,7 (168 értékelés)
6,5
6,5
Felhasználó avatár
My name is Manas Kumar and I'm the CEO of Objectsol, a leading cross platform technology development service provider emphasising on the latest web applications, desktop applications, cross platform mobile applications and data science in a cost-effective way. I'm excited to introduce you to our database optimization project. I understand that you are looking for a skilled database developer who can optimize your MySQL query or index the database to improve performance. The database is currently 1.3GB in size and is used for transactional processing. There are specific tables and queries causing performance issues that need to be addressed. The specific table is approximately 200k rows and the query takes 10 seconds to complete but needs to be closer to 1 second for accuracy. As part of our approach for optimizing the database we will take into consideration your specific needs and requirements as well as the existing structure of the database. We will also provide an estimate timeline for completion of the project so that you can plan ahead.
$140 USD 7 napon belül
4,8 (13 értékelés)
6,1
6,1
Felhasználó avatár
Hello, Joseph How are you? I can optimize the query to run in ONE second perfectly! Please provide me the exact table structure and the query. I have rich experience in large MySQL database(over 1Gbyte) optimization and indexing. I am very familiar with indexing for select, where columns and also querying SQLs for speed optimization. So I am sure I can complete this task in few hours. Please send me a message so that we can discuss more. Thanks, Teo.
$100 USD 1 napon belül
5,0 (7 értékelés)
5,5
5,5
Felhasználó avatár
Greetings! I have read your description carefully and understand what you actually need. I am an experienced developer and can handle this project easily and in perfect manner. I am available now and can start right away, I will develop it in the least time. I am an experienced and professional developer so everything will be well managed. I assure you the work will be provided with quality. Waiting for your response, feel free to get in touch. Thanks!
$250 USD 4 napon belül
5,0 (3 értékelés)
5,3
5,3
Felhasználó avatár
Hi there! Let me help you out... I can help you to optimize the performance of the SQL Queries if you can share the specific SQL Queries with related table definitions. I know 500-level things about Microsoft SQL Server. I have 8 years of exceptional knowledge and experience in both SQL Server Prod & Dev environments. Please feel free to ask for adjustment if my Bid Amount or Hourly Rate does not suit your budget. Warm regards, Kundan Bihari (Freelance SQL Server Consultant)
$100 USD 1 napon belül
5,0 (34 értékelés)
5,1
5,1
Felhasználó avatár
Hi there I can help with the performance tuning and optimizing. Please message me. Thanks Suguna.
$250 USD 7 napon belül
4,9 (34 értékelés)
5,3
5,3
Felhasználó avatár
Greetings I can surely help you for Optimize MySQL query or index the database to optimize I am in the IT industry since more than a decade and serve so many clients in building and rebuilding websites, software, and applications I have strong hands-on different programming languages like PHP, CSS 3, Laravel, C++, C- Sharp, HTML, JAVA, .NET, Joomla, Click funnel, Angular, React, Node.js, Django, etc., And I did the migration from HTML to click funnels. I have made so many websites (E-commerce, WordPress, Classified admin, WooCommerce, etc.), bots, softwares, and Mobile applications (Android, IOS, and Huawei Play store) in my entire career. I have strong hands on both the front end and back end. Currently, I am part of the team who are dealing with miscellaneous tasks in dubizzle and Mzad Qatar including design and layouts and they both have more than 1 million users. I believe that you are looking for a web designer and for sure you will get your end desire result with plagiarism-free work and with better quality as I am assuring you this. Package deals can also be done for long-term collaboration as per the client's requirement. Kindly do come on chat so that we can discuss project details furthermore.
$30 USD 2 napon belül
4,5 (91 értékelés)
5,9
5,9
Felhasználó avatár
Hello, Joseph! Going through your job description, I found that it's perfectly fit for me. As I have a rich experience in this database optimization, so I'm full of confident in your project. I can start work immediately and show satisfied result in your deadline. I will look forward to your replying Thanks
$140 USD 7 napon belül
5,0 (6 értékelés)
4,8
4,8

Az ügyfélről

UNITED STATES zászlója
Sarasota, United States
4,9
6
Fizetési mód hitelesítve
Tagság kezdete: okt. 11, 2018

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.