Optimize MySQL query or index the database to optimize

Fermé Publié le il y a 3 mois Paiement à la livraison
Fermé Paiement à la livraison

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.

MySQL Administration de Bases de données PHP Programmation de bases de données SQL

Nº du projet : #36690414

À propos du projet

65 propositions Projet à distance Actif il y a 2 mois

65 freelances font une offre moyenne de 158 $ pour ce travail

ahmadayaz

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 th Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(295 Commentaires)
8.7
nabeelawais83

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 1 Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(310 Commentaires)
7.7
seefattechnologi

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 an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(108 Commentaires)
7.9
Rekhathakur

** 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 follo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(73 Commentaires)
7.3
schoudhary1553

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 look Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 5 jours
(150 Commentaires)
7.3
ShrineWeb

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(136 Commentaires)
6.8
c0909h1179

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!

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(35 Commentaires)
6.5
developersshop

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4294967295 jours
(154 Commentaires)
6.7
Waqaskhan591

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(106 Commentaires)
6.7
fanninson45

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(38 Commentaires)
6.5
smandalsl

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 Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(13 Commentaires)
6.1
furqaanwar

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 stru Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(15 Commentaires)
6.1
vitalykuzin

Hello there! My name is Vitaly, and I'm a highly experienced freelancer with more than 15 years of experience in the technology industry. I specialize in developing web/mobile applications and have worked on numerous p Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(24 Commentaires)
6.2
b0b90

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 o Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(54 Commentaires)
5.9
navjootkaur

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 & Develo Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(163 Commentaires)
6.5
EmmaWat

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 aw Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 4 jours
(3 Commentaires)
5.3
imranahsan1

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, an Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(91 Commentaires)
5.9
kundansql

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 Ser Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% USD en 1 jour
(32 Commentaires)
5.1
Sugidev

Hi there I can help with the performance tuning and optimizing. Please message me. Thanks Suguna.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(33 Commentaires)
5.3
martinbuz123

I understand from your description that you are looking for a skilled database developer who can optimize your MySQL query or index the database to improve performance. With over 8 years of experience in the field, I a Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 7 jours
(2 Commentaires)
4.6