Moving a payments company’s reporting off the production database
Executive, finance and operations dashboards ran directly on the production database. Its tables are very wide and hold millions of rows, so any range longer than a week crashed the dashboards.
- Reports are more than 10× faster
- Reporting no longer touches production
- The team can ask an AI agent about the data
| Period | Before | First open | Repeat |
|---|---|---|---|
| 24 hours | 30+ s | 2.5 s | 2.3 s |
| 7 days | Crashes | 2.3 s | 2.0 s |
| 30 days | Crashes | 4.6 s | 2.5 s |
| 90 days | Crashes | <10 s | 1.9 s |