Optimize MySQL query or index the database to optimize
Betalt ved levering
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.
Projekt ID: #36690414
65 freelancere byder i gennemsnit $158 timen for dette job
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
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!