Overview
Challenges
- DB growth disproportionate to daily transaction
- Huge time taken to generate simple reports
- Lot of time taken to input the daily transactions
- Unable to process month-end on-time
Our Solution
- Daily DB monitoring to check the DB growth
- Dump and load in TEST DB to show the difference
- Replicated the dump and load in live
- Rebuilt the indexes
Key Benefits
- DB size got reduced from 93GB to 3GB
- Reports and process are getting done in less than 3 minutes time
Key Differentiators
- Daily DB monitoring with purpose
- Focused on addressing business concerns