Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Expand]ASP.NET Controls and MVC Extensions
[Collapse]ASP.NET Bootstrap Controls
 [Expand]Getting Started
 [Collapse]Grid View
  [Collapse]Binding to Data
    Connecting Bootstrap Grid View 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 Row Caching
  [Expand]Data Representation Basics
  [Expand]Data Summaries
  [Expand]Filtering
  [Expand]Grouping
   Sorting
  [Expand]Focus and Navigation
  [Expand]Data Editing
  [Expand]Master-Detail Relationship
   Export Overview
   Data-Toggle Attribute
 [Expand]Charts
 [Expand]Data Editors
 [Expand]Site Navigation and Layout
 [Expand]API Reference
[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]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Binding to Large Data (Database Server Mode)

The Bootstrap Grid View control supports a specific binding mode designed to work with large datasets. Within this binding mode, data-aware operations (sorting, grouping, 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 Bootstrap Grid View is bound to data via one of the following components that provides data : LinqServerModeDataSource, EntityServerModeDataSource or XpoDataSource. When an end-user performs data operations (sorting, grouping, etc.), a component providing data 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 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.

For end-users, the Grid View 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, group and filter data, calculate summaries, etc.

Expanded Concepts

Expanded See Also

How would you rate this topic?​​​​​​​