The project budget is a little low, but database troubleshooting is one of the things I love.
If you can export your MySQL database, I would love to first examine it in my own non-production setting. If that is not possible, then I can directly examine the dB with the necessary connectivity information.
Fundamental design
Indexes
Rebuilding indexes
Ensuring proper referential integrity of Primary Keys and Foreign Keys are indexed where appropriate with indexes suited for the appropriate low/high cardinality of the data within a given column.
With 60,000 records, I will be able to troubleshoot and optimize your database to let you know why what is happening, is happening, outline the steps to resolve the issue(s), implement the solution(s).
I am new to Freelancer, and I am hoping I get a response to a bid soon! Even a response requesting additional information from me would be wonderful.
I can add additional milestones if you prefer.
Sincerely,
Emerson