Optimize MySQL query or index the database to optimize

Suljettu Julkaistu 3 kuukautta sitten Maksettu toimituksen yhteydessä
Suljettu Maksettu toimituksen yhteydessä

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 Tietokannan hallinto PHP Tietokantaohjelmointi SQL

Projektin tunnus: #36690414

Tietoa projektista

65 ehdotusta Etäprojekti Aktiivinen 2 kuukautta sitten

65 freelanceria on tarjonnut keskimäärin $158 tähän työhön

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 Lisää

$225 USD 10 päivässä
(295 arvostelua)
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 Lisää

$90 USD 1 päivässä
(310 arvostelua)
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 Lisää

$250 USD 3 päivässä
(108 arvostelua)
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 Lisää

$250 USD 7 päivässä
(73 arvostelua)
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 Lisää

$180 USD 5 päivässä
(150 arvostelua)
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

$30 USD 10 päivässä
(136 arvostelua)
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!

$222 USD 2 päivässä
(35 arvostelua)
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 Lisää

$250 USD 4294967295 päivässä
(154 arvostelua)
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 Lisää

$150 USD 3 päivässä
(106 arvostelua)
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 Lisää

$140 USD 7 päivässä
(38 arvostelua)
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 Lisää

$140 USD 7 päivässä
(13 arvostelua)
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 Lisää

$350 USD 7 päivässä
(15 arvostelua)
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 Lisää

$140 USD 7 päivässä
(24 arvostelua)
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 Lisää

$140 USD 7 päivässä
(54 arvostelua)
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 Lisää

$140 USD 7 päivässä
(163 arvostelua)
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 Lisää

$250 USD 4 päivässä
(3 arvostelua)
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 Lisää

$30 USD 2 päivässä
(91 arvostelua)
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 Lisää

$100 USD 1 päivässä
(32 arvostelua)
5.1
Sugidev

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

$250 USD 7 päivässä
(33 arvostelua)
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 Lisää

$140 USD 7 päivässä
(2 arvostelua)
4.6