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
V18.2
Dashboard
Getting Started
Basic Concepts and Terminology
Common Features
Supported Data Sources
Connecting to a Data Source
Data Processing Modes
Custom Connection Strings for the SQL Data Source
Data Preparation
Binding to Data
Data Shaping
Interactivity
Appearance Customization
Advanced Analytics
Dashboard Layout
Printing and Exporting
Creating the Designer and Viewer Applications
Creating Dashboards
Visual Studio Integration
End-User Documentation
Localization
Redistribution and Deployment
Video Tutorials
Examples
Member Tables
.NET Framework API Reference
.NET Core API Reference
JavaScript API Reference
Download CHM

Data Processing Modes

  • 2 minutes to read

DevExpress Dashboard supports two data processing modes that are used to perform data-related operations (such as grouping, filtering, etc.):

  • In server mode, data-related operations are performed on the database server side. For instance, when an end-user applies filtering to a dashboard item, the Dashboard requests the required data automatically by sending a query containing a corresponding SELECT statement with the specified WHERE clause.
  • In client mode, data-related operations are performed on the workstation side (in the case of WinForms Designer/Viewer) or web server side (in the case of Web Dashboard or Web Viewer). In this mode, a compressed snapshot of aggregated data is loaded into a workstation/web server memory. This reduces memory consumption and improves the speed of client-side data shaping operations using several techniques: data compression, various data grouping, and multi-threading algorithms, etc.

Refer to the required control’s topic to learn how to manage a data processing mode.

Tip

Note that performance in server/client modes depends on multiple factors such as database structure, server workload, etc. Test both to decide which mode to use.

Note

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