Server Data and Large Data Sources

  • 2 minutes to read

In regular data binding modes, a data-aware control 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.

Virtual Sources allow you to bind the GridControl to any data source, even if the total record count is unknown:

The GridControl allows you to navigate between data portions on demand, and carry out all data shaping operations on the server side - Server Modes:

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

Virtual Source

Instant Feedback

Server Mode

Load Data on Demand

yes

yes

yes

Load Data Asynchronously

yes

yes

no

Dynamic Properties

yes

no

no

Data Editing

yes*

no

no

Sorting

yes*

yes

yes

Filtering

yes*

yes

yes

Grouping

no

yes

yes

Summary

yes*

yes

yes

Custom Summary

yes*

no

no

Build Custom Queries

yes**

no***

no***

*  The Virtual Source components disable data operations. To enable an operation, enable the GridControl's option and handle a data source event. Refer to the How to Use Virtual Sources topic for more information.

**  The Virtual Source components provide events to load data. You can use any data access technology.

***  In server modes you cannot customize queries from data sources that use the following data access technologies.