RadGridView, billions of rows and loading on-the-fly

[Oliver]

Hi,

we're using a RadGridView for displaying result sets of dynamic database queries. These queries are user-customizable and may (especially during design phase) yield several billions of rows.

The RadGridView is configured to use row virtualization. However, when using an IEnumerable-derived ResultsSet (which will load the requested items on the fly), all items are enumerated before the first few are being displayed. This operation requires a lot of memory and fails for larger result sets.

Before investing effort in implementing IQueryable for the ResultsSet object, we'd like to ensure this would enable us to dynamically load the currently displayed rows only.

Does anyone have any experience using RadGridView in such a scenario?

Any help is greatly appreciated!

Best regards,

Oliver

[Dimitrina]

Hello Oliver,

We can suggest you considering either:
- RadDataPager or
- VirtualQueryableCollectionView. Please keep in mind this collection was designed to mostly serve ReadOnly scenarios and its capabilities are limited. You can find more information on the collection in the Using Data Virtualization documentation

As you mentioned IQueryable, if you implement IQueryable and bind RadGridView to it, it will then automatically append filtering (Where), sorting (OrderBy) and grouping (GroupBy) expressions on this IQueryable.  

Regards,
Dimitrina
Telerik