Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Collapse]WPF Controls
  Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Expand]MVVM Framework
 [Collapse]Controls and Libraries
  [Expand]Windows and Utility Controls
   Dialogs, Notifications and Panels
   Reporting
  [Collapse]Data Grid
   [Expand]Getting Started
   [Expand]Implementation Details
   [Expand]Views
   [Expand]Grid View Data Layout
   [Collapse]Binding to Data
     Binding to Data Overview
     Binding to ICollectionView
    [Expand]Binding to any Data Source with Virtual Sources
    [Collapse]Server Mode
      Server Mode Overview
      Entity Framework 4.0+ Server Mode
      LINQ Server Mode
      Binding to In-Memory Data Using PLINQ
      Server Mode Limitations
     Instant Feedback UI Mode
    [Expand]TreeListView Data Binding
     Applying Data Annotations
     Unbound Columns
     Posting Data to a Connected Database
     Managing Multi-Thread Data Updates
   [Expand]Master-Detail Data Representation
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Selection
   [Expand]Filtering and Searching
   [Expand]Sorting
   [Expand]Data Summaries
   [Expand]Paging and Scrolling
   [Expand]Focus and Navigation
   [Expand]Conditional Formatting
   [Expand]Drag-and-Drop
   [Expand]Appearance Customization
   [Expand]MVVM Enhancements
   [Expand]Printing and Exporting
   [Expand]End-User Interaction
   [Expand]Miscellaneous
   [Expand]Performance Improvement
   [Expand]Design-Time Features
   [Expand]Visual Elements
   [Expand]End-User Capabilities
   [Expand]Examples
  [Expand]Ribbon, Bars and Menu
  [Expand]Charts Suite
  [Expand]Pivot Grid
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Tree List
  [Expand]Gauge Controls
  [Expand]Map Control
  [Expand]Layout Management
  [Expand]Windows Modern UI
  [Expand]Printing-Exporting
  [Expand]Data Editors
  [Expand]Navigation Controls
  [Expand]Spell Checker
  [Expand]Property Grid
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Diagram Control
  [Expand]Scheduler (legacy)
 [Expand]Scaffolding Wizard
 [Expand]Localization
  Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Server Mode Overview

The DXGrid supports a binding mode designed to work with massive datasets. This is called server mode. With this mode, even if the grid control is connected to a data store containing one million records, the initial data will be displayed immediately, and subsequent data will be loaded rapidly on scrolling. Loading records in small portions, and performing data-aware operations on the data server side are the key features of server mode that ensure quick access to data, even if the sorting, grouping, filtering and summary features are used.

Expanded Overview

Server mode has been specifically designed to work with large datasets. Bound data is not loaded into memory in its entirety. Instead, the grid control loads data in small portions, on demand. When the grid starts, it loads and displays the first portion of data from the data store. Then, as an end-user scrolls the grid, when the last record of the loaded subset is reached, the grid requests the data store to return a subsequent section of data.

In regular data binding mode, before it's displayed within a grid control, data must be fetched in its entirety from a data store into memory. The number of records is a bottleneck, as the more records there are, the more time is required to load the data. Moreover, the grid's performance also depends on the total number of loaded records, particularly when data is sorted, grouped, filtered or the summary feature is used. In this case, the grid needs to process the entire recordset to implement a specific data-aware operation.

The DXGrid automatically operates in server mode if it is bound to a data source that supports the DevExpress.Data.IListServer interface. Currently, you can use the LinqServerModeSource, XPServerCollectionSource, EntityServerModeSource or WcfServerModeSource component as a data source in server mode. These components support the System.ComponentModel.IListSource interface, and return the list implementing the DevExpress.Data.IListServer interface via their List properties.

If a data source doesn't implement the DevExpress.Data.IListServer interface, server mode is not available.

Server mode cannot be used in master-detail mode.

Expanded Concepts

Expanded Examples

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