The ASPxGridView supports server mode - a binding mode that is specifically designed to work with large datasets (50,000+ records) using XPO.
With the XpoDataSource component, you can bind our data-aware controls to any database supported by XPO. For the bound control
(and grid control in particular), the number of records to load is a bottleneck, as the more records there are, the more time is required to load data.
To alleviate this problem when using the XpoDataSource, we have developed server mode.
In this mode, the grid control loads records in small portions, on demand, and performs data-aware operations (sorting, filtering, grouping, etc.)
on the data server side. This greatly improves the grid's speed and responsiveness.
However, since bound data is not loaded entirely into memory in server mode, the following grid features are not supported:
- Filtering and sorting data by display text (not by edit values).
- Custom sorting and custom grouping implemented via the grid control's CustomColumnSort and CustomColumnGroup event handlers.
- Group modes specified by a column's Settings.GroupInterval property (rows are always grouped by values of grouping columns).
- Calculating custom summaries via the grid control's CustomSummaryCalculate event handler.
- A data table whose primary key is composed of several columns cannot be used as a data source.
To enable server mode for the grid control, bind it to a data source via the XpoDataSource, and set the XpoDataSource.ServerMode property to true.
In this demo, you can see for yourself how fast our grid control performs various operations (such as sorting, filtering, and grouping), and calculates summaries against 300,000 records in server mode. The demo shows the grid operation that has been performed and the time required.