Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]Welcome to DevExpress .NET Documentation
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
   Getting Started
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Collapse]Vertical Grid
   [Expand]Product Information
   [Expand]ASPxVerticalGrid Getting Started
   [Expand]Fundamentals
   [Collapse]Concepts
    [Collapse]Binding to Data
      Connecting ASPxVerticalGrid to a Data Source
     [Collapse]Binding to Large Data (Database Server Mode)
       Data Binding to Large Data via EF
       Data Binding to Large Data via LINQ
       Data Binding to Large Data via XPO
       Database Server Mode Limitations
      Built-in Record Caching
    [Expand]Data Representation Basics
    [Expand]Focus and Navigation
    [Expand]Data Editing
    [Expand]Data Shaping and Manipulation
    [Expand]Data Formatting
     Appearance Customization
     Templates
     Export
     Toolbars
    ASPxVerticalGrid Designer
   [Expand]Visual Elements
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Expand]Pivot Grid
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[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

Binding to Large Data (Database Server Mode)

The ASPxVerticalGrid control supports a specific binding mode designed to work with large datasets. Within this binding mode, data-aware operations (sorting, filtering, etc.) are performed on the database server side, which is why this mode is called database server mode.

Expanded Database Server Mode vs. Regular Binding Mode

In server mode, the ASPxVerticalGrid is bound to data using one of the following data providing components: LinqServerModeDataSource, EntityServerModeDataSource or XpoDataSource. When an end-user performs data operations (sorting, filtering, etc.), a data providing component analyzes the grid's current state and generates smart queries to receive only those records that must be displayed on screen. These requests are passed to the associated queryable source. The queryable source translates these requests into the required queries and executes them. This ensures a quick response and improved performance for large data sources.

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 the 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, filtered or the summary feature is used. In this case, the grid needs to process the entire record set to implement a specific data-aware operation.

For end-users, the ASPxVerticalGrid functions identically in regular and server modes. In server mode, end-users can use an automatic filtering feature to access a particular data range, sort and filter data, calculate summaries, etc.

Expanded Concepts

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