This article describes the dashboard's server-side data caching functionality, corresponding API, and how to update the cached data.
The ASPxDashboard control can display dashboards supplied with data using different types of data sources, which include SQL databases, Excel files, Entity Framework data sources, etc. If a data source uses the Server data processing mode, ASPxDashboard requests data automatically by sending a query containing a corresponding SELECT statement.
If the Client data processing mode is enabled for the data source, ASPxDashboard creates a server-side in-memory cache that stores data from the data source in an optimized way. This capability accelerates specific client-side actions that require data updates (for instance, when you apply master filtering).
The in-memory cache is created when data is loaded for the first time. The Web Dashboard can create several caches to accelerate data loading for different dashboards/data sources. Depending on the server-side API in use, the following specifics are applied to cache sharing:
The parameter name-value pair is included in the cache key - users get the cache only for the corresponding user group. Parameters added in the CustomParameters event is not passed to the client.
Cache Life Cycle
The Web Dashboard manages the in-memory cache in the following independent ways:
The Web Dashboard clears the cache if the time interval between two data requests exceeds 300 seconds. If the time interval between two data requests is less than 300 seconds, the Web Dashboard leaves the old cache unchanged and starts the timer again.