Skip to main content
BuyLog In
Business Intelligence Dashboard
Search in…
Docs > Basic Concepts and Terminology > Data Processing Modes
All docs
V24.2
Business Intelligence Dashboard
Get Started
.NET Support
What's New
Basic Concepts and Terminology
What is BI Dashboard
Dashboard
Dashboard Designer
Dashboard Viewer
Dashboard Items
Data Sources
Measures and Dimensions
Data Processing Modes
Desktop (WinForms and WPF) and Web Specifics
BI Dashboard Performance
Common Features
WinForms Dashboard
Web Dashboard
WPF Dashboard Viewer
Visual Studio Integration
Redistribution and Deployment
Video Tutorials
Migration Guides
Examples
End-User Documentation
.NET Framework API Reference
.NET 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 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. The dashboard control executes a case-sensitive string comparison when you use Calculated Fields or Master Filtering functionality in Client data-processing mode. Set the DashboardSettings.UseCaseSensitiveDataProcessing property to false to disable case-sensitive string comparison.

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.