We are working on a project which stores data in database and produces reports as per various queries, portal is completed but we are facing issues with report generation as its taking to long for report generation. There are 2.5 million records in the database, people who are experts in mysql architecture and java kindly bid as we need to fix the issue immediately.
Only experts apply as the issue is slightly more complex
8 freelancers are bidding on average ₹319/hour for this job
5+ years of experience in Java. Very good at any SQL's. Can help you out in fixing this for sure. I am sure I can satisfy you. Hoping to listen back from you.
As a programmer 2.5 million records in MySQL is a huge amount. Indexing is mostly required. Retrieve process and storing into different lists or maps is mainly focused for efficiency.