Improving the Performance of Your Dashboards
TL;DR
- Slow dashboards are usually a database architecture problem, not a frontend or charting library problem.
- Running analytical queries on your transactional database degrades your entire application's performance and reliability.
- Moving these analytical queries to ClickHouse yields 10–100x faster dashboards
This guide will:
- Help you recognize when OLTP has become your analytics bottleneck
- Show an incremental path to move analytical workloads to OLAP
- Walk through shipping the change end-to-end with MooseStack + ClickHouse