1
Vote

Requirement:

  • Reduce the hit and load on SQL server when working with dashboards

Proposal

  • Add a caching mechanism in the server end that will catch the queries and its data sets so that a subsequent request with the same query will return the cached data.
  • A user-level setting needs to be provided to control the behavior of caching so that the user can customize the caching behavior for each data source.