Skip to main content
BuyLog In
WPF Controls
Search in…
Docs > WPF Controls > Controls and Libraries > Data Grid > Performance Improvement > Big Data Source
All docs
V24.2
WPF Controls
Prerequisites
What's New
What's Installed
.NET/.NET Core Support
Common Concepts
MVVM Support
MVVM Framework
Controls and Libraries
Reporting
Data Grid
Getting Started
Comparison: Standard WPF DataGrid and DevExpress WPF GridControl
Troubleshooting
Implementation Details
Views
Grid View Data Layout
Bind to Data
CRUD Operations
Display Hierarchical Data
Master-Detail Data Representation
Data Editing and Validation
Grouping
Filtering and Searching
Sorting
Data Summaries
Paging and Scrolling
Focus, Navigation, Selection
Drag-and-Drop
Conditional Formatting
Appearance Customization
MVVM Support
Printing and Exporting
Miscellaneous
Performance Improvement
Scrolling Speed
Frequent Data Updates
Manage Multi-Thread Data Updates
Big Data Source
Optimized Mode
Design-Time Features
Visual Elements
End-User Capabilities
Accessibility
Examples
Ribbon, Bars and Menu
Charts Suite
Pivot Grid
Scheduler
Spreadsheet
Rich Text Editor
Tree List
Gauge Controls
Map Control
Layout Management
Windows Modern UI
Printing-Exporting
Data Editors
Navigation Controls
Spell Checker
Property Grid
PDF Viewer
TreeMap Control
Gantt Control
Diagram Control
Windows and Utility Controls
Dialogs, Notifications and Panels
Office File API
Sankey Diagram Control
Sunburst Control
Heatmap Control
Scheduler (legacy)
AI-powered Extensions
Localization
Security Considerations
Support, Debug, and Troubleshooting
Redistribution and Deployment
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

Big Data Source

  • 3 minutes to read

The GridControl loads the entire dataset to memory in regular binding mode. In this case, the GridControl processes loaded data (sorts, groups, filters, etc.) in the client-side application. This binding mode provides unlimited data shaping capabilities (for example, custom sorting, custom grouping, etc.), but the control may work slowly when it is bound to a large data set in regular binding mode.

We recommend enabling server-side data processing if the control works slowly due to a large number of data records in a bound data source:

  • The GridControl does not process (sort, group, filter, and etc.) loaded items: the database server (or Odata service) processes data items.
  • The GridControl loads only those items it displays on screen.

The GridControl supports the following binding modes that enable server-side data processing:

Server Mode

The DevExpress WPF subscription ships with a set of Server Mode data source controls. Bind the GridControl to data via a Server Mode data source control to automatically enable server-side data processing. Server Mode data source controls support the following data access technologies:

Refer to Server Mode Overview for more information.

Instant Feedback Mode

The Instant Feedback mode sources enable the server-side data processing in a background thread.

The application’s UI remains responsive while the GridControl loads its data items. This allows users to sort, filter, and group data items. The current request to a data source may become outdated if an end-user has manipulated the control’s data items. In this case, the GridControl cancels the previous request and initiates a new request to the data source.

The Instant Feedback mode sources support the following data access technologies:

Learn More: Instant Feedback UI Mode

Virtual Data Sources

Virtual Sources allow you to implement your data loading logic. You can bind the GridControl to any data source via the Virtual Sources, even if the total record count is unknown.

The GridControl only loads items it displays on screen or a certain page, and you can specify the supported data operations.

Refer to Binding to any Data Source with Virtual Sources for more information.

See Also