[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report and Dashboard Server
[Collapse]Dashboard
 [Expand]Getting Started
 [Expand]Basic Concepts and Terminology
 [Collapse]Common Features
   Supported Data Sources
  [Collapse]Connecting to a Data Source
    Data Processing Modes
    Custom Connection Strings for the SQL Data Source
   Data Preparation
   Binding to Data
  [Expand]Data Shaping
  [Expand]Interactivity
  [Expand]Appearance Customization
  [Expand]Advanced Analytics
   Dashboard Layout
   Printing and Exporting
 [Expand]Creating the Designer and Viewer Applications
 [Expand]Creating Dashboards
 [Expand]Visual Studio Integration
  End-User Documentation
  Localization
 [Expand]Redistribution and Deployment
  Video Tutorials
 [Expand]Examples
 [Expand]Member Tables
 [Expand]API Reference
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Data Processing Modes

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.

Is this topic helpful?​​​​​​​