We have a platform based in PHP and MySQL on AWS, the app generate intensive SQL selects to generate reports. We need to optimize it at least in the code side, database structure (indexes, etc) and MySQL tuning.
- SQL to review: 30 approx.
- Tables to review: 15 approx.
- 2,7 GB
24 freelancers are bidding on average $167 for this job
Hello, I can help you with this project, I have the necessary experience and I can assure you that our collaboration will bring good results. Best regards, Andrei
i am software engineer.I have read the description and i would like to work for you.I can complete your task in [login to view URL] further details please inbox me. Thank you.
1. Need to check all the tables. 2. Need to verify Primary/Secondary Indexes on all the tables & analyse. 3. Need to check if any partition helps or already exists.