Performance investigation and testing were conducted for the Insights Dashboards to reduce runtime and verify compliance with the defined runtime targets. These tests resulted in changes to the dashboard query architecture. Additional tests were then performed to measure the impact of these changes. Below is a summary of these tests.
Test Summary
-
Test Data Size – 50 million transaction rows.
-
Test Process – Each dashboard was tested with the performance changes applied, and the average runtime was calculated.
-
Target Runtime – 10 seconds; for large datasets (more than 20 million transaction rows), 30 seconds.
|
Dashboard |
Average Runtime |
|---|---|
|
Revenue and Profit Dashboard |
~30 seconds |
|
Customers Overview Dashboard |
~30 seconds |
|
Customer Trends Dashboard |
~10 seconds |
|
Customer Performance Dashboard |
~3 seconds |
Applied Performance Changes
-
A single query was split into multiple queries.
-
The most performance-intensive queries were rewritten from QueryAPI to DatamartContext queries.