Introduction #
SmartChart provides a two-level data refresh mechanism: frontend scheduled refresh (browser periodically requests backend) and backend cache acceleration (database queried once, then cache hits). Proper configuration of both ensures data real-time performance while greatly reducing database pressure.
Data Refresh Configuration #
SmartChart provides fine-grained data refresh and memory acceleration features.
You can configure in the dataset development interface menu: Connection icon -> Refresh Settings
Scheduled Refresh #
You can set the interval for the frontend to request data refresh from the backend, in seconds.
If data doesn’t change after scheduled refresh, it may be because the cache time is longer than the refresh interval
Dataset Cache Acceleration (PRO) #
SmartChart Pro provides memory acceleration technology. The database is queried only once, then subsequent responses are millisecond-level:
- Interval refresh in minutes. E.g., setting 0.5 means if the next access is over 30 seconds later, data refresh is triggered
- Fixed time refresh. Setting interval to -1 triggers refresh at a fixed time point (e.g., daily at 12:39)
- Force refresh. Add &refresh=Y to the URL. This does not affect interval or fixed refresh timing
Dataset Status #
Dataset status determines loading method (sync/async) and trigger timing (auto/manual):
| Status | Group | Scheduled | Manual | Async | Container |
|---|---|---|---|---|---|
| Standard Chart | 0 | Non-negative | X | Y | Yes |
| VUE Chart | 0 | Non-negative | X | X | Yes |
| Shared Dataset | -2 | Non-negative | X | X | No |
| Lazy-load Chart | 0 | -1 | Y | X | Yes |
| Lazy-load Dataset | -2 | -1 | Y | X | No |
| Lazy-load Dataset | -2 | -2 | Y | Y | No |
| Excel Dataset | -3 | Non-negative | X | X | No |
| Static Component | -1 | -1 | X | X | Yes |
Status Selection Guide:
- Real-time dashboard charts → Standard chart + frontend scheduled refresh 30~60s
- Download/filter trigger → Lazy-load dataset
- Shared data to avoid duplicate queries → Shared dataset