The developer is required to work on an existing copy of our MySql DB and optimize its performance.
The DB is composed of around 30 tables and is around 2.6Gb big.
The biggest table alone is about 2Gb because it stores a lot of text in a text field. This table uses MyISAM engine and this must be preserved, cannot be partitioned because we run fulltext queries on it.
Fulltext select are very slow and we need to solve this problem.
Every modification to the DB must be provided in SQL so we can replicate it on the live DB when the performance issue will be solved.
23 freelancers estão ofertando em média €628 nesse trabalho
Hello there, I’m Virang Patel, a Professional and Expert Software Engineer. I am interested in doing this job for you. Ready to start the project. Looking forward to hearing from you. Thank you Virang
hi, how are you? I've already worked for this type project. I want you to discuss with me about further more project specification. Thanks regards.