[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
  Prerequisites
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Collapse]Data Grid
   [Expand]Get Started With Data Grid and Views
   [Collapse]Data Binding
    [Collapse]Large Data Sources: Server and Instant Feedback Modes
      Data Stores Supported in Server Mode When Using XPO
      Server Mode: Binding to a Data Source Using XPO
      Entity Framework 4.0+ Server Mode Specifics
     Post Data to an Underlying Data Source
    Unbound Columns
   [Expand]Views
   [Expand]Data Editing and Validation
   [Expand]Grouping
   [Expand]Sorting
   [Expand]Filter and Search
   [Expand]Summaries
   [Expand]Focus and Selection Handling
    Format Cell Values
   [Expand]Master-Detail Relationships
   [Expand]Asynchronous Image Load
   [Expand]Export and Printing
   [Expand]Appearance and Conditional Formatting
    Split Presentation
    Row Preview Sections
   [Expand]Scrolling
   [Expand]Batch Modifications
    Hit Information
    Hints
    Popup Menus
   [Expand]Save and Restore Layout
   [Expand]Visual Elements
   [Expand]Design-Time Features
   [Expand]Examples
   [Expand]End-User Capabilities
    Included Components
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Diagrams
  [Expand]Gauges
  [Expand]Map Control
  [Expand]Scheduler
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]Printing-Exporting
  [Expand]PDF Viewer
   Reporting
  [Expand]Snap
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[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
[Expand]Dashboard
[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)

Large Data Sources: Server and Instant Feedback Modes

Documentation

Demos (links require the DevExpress Demo Center of version 16.2 or newer to be installed)

Examples

Expanded What are Server Modes?

In regular data binding modes, a Data Grid loads an entire data set at once, which, in cases of large data volumes, significantly slows down application startup and consumes a considerable amount of memory. The overall Data Grid performance depends on a customer's rig, and data shaping operations (sorting, grouping or filtering) may cause a bottleneck.

Server modes address this issue by loading data in small portions on demand and carrying out all data shaping operations server side.

The "server modes" term includes two separate modes:

  • a regular (synchronous) server mode locks the GUI and does not respond to end-users' actions when data is retrieved;
  • an Instant Feedback mode (asynchronous server mode) loads data in a background thread, so that the GUI remains responsive in the process. This mode is not supported in the GridLookUpEdit control.

Expanded Feature Limitations and Specifics

In server modes, grid controls (GridControl, GridLookUpEdit, and SearchLookUpEdit) do not have simultaneous access to bound data in its entirety. This imposes certain limitations on the grid's features that are still available in a regular binding mode. Please see the list below for information on features that are not supported/not recommended in server mode.

To learn about known issues when using Entity Framework data sources in Server Mode and how to overcome them, please refer to Entity Framework 4.0+ Server Mode Specifics.

Expanded Server Mode Data Sources

To enable a specific server mode for your data-aware control, you need to use an appropriate data source. You can use data sources provided by the eXpress Persistent Objects (XPO) library, or use dedicated data sources tailored to work with 'LINQ to SQL Classes'. Thus, choose one of the following data sources for your control.

Data Access Technology

Server Mode Data Source

Instant Feedback UI Data Source

Entity Framework 4+

EntityServerModeSource

EntityInstantFeedbackSource

XPO

XPServerCollectionSource

XPServerModeView

XPInstantFeedbackSource

XPInstantFeedbackView

LINQ to SQL

LinqServerModeSource

LinqInstantFeedbackSource

Parallel LINQ to Objects

PLinqServerModeSource

PLinqInstantFeedbackSource

WCF Data Services

WcfServerModeSource

WcfInstantFeedbackSource

OData v4

ODataServerModeSource

ODataInstantFeedbackSource

Expanded Infinite Scrolling - Virtual (Event-Based) Server Mode

In addition to two "classic" data-on-demand Grid modes (Server Mode & Instant Feedback), you can use the event-based VirtualServerModeSource component to manually implement the batch data loading. A Data Grid bound to this data source component supports the Infinite Scrolling feature.

Refer to the Infinite Scrolling demo for an example.

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