Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > Common Features > Connecting to a Data Source > Data Processing Modes
A newer version of this page is available. .
All docs
V19.1
Dashboard
Get Started
Basic Concepts and Terminology
Common Features
Supported Data Sources
Connecting to a Data Source
Data Processing Modes
Custom Connection Strings for an SQL Data Source
Data Preparation
Binding to Data
Data Shaping
Interactivity
Appearance Customization
Advanced Analytics
Dashboard Layout
Printing and Exporting
Create the Designer and Viewer Applications
Create Dashboards
Visual Studio Integration
End-User Documentation
Localization
Redistribution and Deployment
Video Tutorials
Migration Guides
Examples
Member Tables
.NET Framework API Reference
.NET Core API Reference
HTML JS Control API Reference
ASP.NET Client API Reference
Download CHM

Data Processing Modes

  • 2 minutes to read

A data processing mode determines how the DevExpress Dashboard performs data aggregation and filtering operations. There are two data processing modes:

  • Server mode. Data-related operations are performed server side. When an end-user applies a filter to a dashboard item or groups data, the Dashboard composes a SELECT statement with the specific WHERE or GROUP BY clauses, and sends it to the server.
  • Client mode. Data-related operations are performed on the workstation ( WinForms Dashboard Designer or Viewer) or web server side (Web Dashboard controls). The Dashboard loads a compressed snapshot of aggregated data into a workstation/web server memory. Data compression, proper data grouping, and multi-threading algorithms reduce memory consumption and improve data shaping operation performance.

For more information refer to the following topics:

Tip

Several considerations for selecting a mode for the SQL Data Source:

  • With a large number of records, consider server data processing mode. The dashboard performs all calculations server side. When an end-user changes a filter, the dashboard requests data from a data base with new filter values.
  • With a small number of records, it is better to switch to client mode. The dashboard requests all data from the database, caches it on the client side and performs the required calculations. When an end-user changes a filter or other parameters, the dashboard does not request data from the server and uses already received cached data.
  • An application performance depends on multiple factors besides the data processing mode. Consider first the database structure and server workload, then decide which mode to choose.

Note

In OLAP mode, data processing is performed using the server mode specified for the Analysis Services instance. Refer to the Determine the Server Mode of an Analysis Services Instance article for more information.