Dashboard Performance Metrics: Web Live vs. Web Extract
When dealing with large API datasets, it’s important to understand the performance implications of using different data connection modes in your dashboard. This article outlines the expected performance metrics for web live and web extract modes, providing insights into the design time and dashboard loading time for each.
Performance Metrics Overview
The performance of your dashboard can vary significantly depending on whether you are using extract mode or live mode. Below is a comparison of the two modes on 1 million records:
| Mode | Design Time | Dashboard Loading Time |
|---|---|---|
| Extract | 4 mins | 2 seconds |
| Live | 4 mins | 2.5 minutes |
Extract Mode
In extract mode, the data source is set up to fetch data and store it in an structured format in the data store database. This allows for quicker retrieval of data when loading the dashboard. As indicated in the table, the design time for setting up an extract can take around 4 minutes, but once this is done, the dashboard loading time is significantly reduced to just 2 seconds. Data can be updated automatically on a regular schedule to ensure that the most current information is available.
Live Mode
Live mode, on the other hand, connects directly to the API every time an action is performed. This indicates that every time the dashboard is shown, it must obtain information from the API, transfer it to the data store, and then display it on the dashboard. The design time for live mode can take up to 4 minutes, but the dashboard loading time is around 2.5 minutes due to the additional steps required to access the live data.
Additional References
