SQL Performance Tuning .
Budget: ₹12,500 – ₹37,500 INR
We need to process around 20 lakh total rows from MySQL database.
The rows need to be processed through a formula to calculate sum of hourly average for each day and this needs to be done for last 360 days. There will be around 7000 rows daily.
This calculation needs to be performed daily at midnight.
The Process currently takes a long Time approx 30 min.
The rows need to be processed through a formula to calculate sum of hourly average for each day and this needs to be done for last 360 days. There will be around 7000 rows daily.
This calculation needs to be performed daily at midnight.
The Process currently takes a long Time approx 30 min.