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

2 posts, 0 answers
  1. Oliver
    Oliver avatar
    5 posts
    Member since:
    Aug 2012

    Posted 08 Jun 2015 Link to this post

    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

  2. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 10 Jun 2015 Link to this post

    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
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top