[Solved] Grid Virtualization Performance and Virtual PageSize

[David]

Hi,

I am binding a RadGridView to 8000 records or so. I use the default row/col virtualization to ensure it loads the data in "pages". I also load it asynchronously from an observable collection. The height of my grid is set and I do not use value converters (as per your performance tips).

However, clicking on the next page (vertical scrollbar) takes just over a second to load. Your demo with 50 million rows appears to be faster. I'v tried various things but can't speed it up, so I was thinking perhaps I could turn OFF virtualization if there were less than x (maybe 100 records) in the collection and on if there were more. 

The simplest way to do this would be to set the virtual page size (I assume it is set to the visible viewing area) - is there anyway to set this in XAML (or code) to be 100?

Our grids will probably show 100-200 records typically, so for most there will be a slightly longer load time but fast paging (this required due to the nature of our application).

Here is the header declaration:

  <telerikGrid:RadGridView
            Grid.Row="1"
            DataLoadMode="Asynchronous"
            EnableRowVirtualization="True"
            ShowGroupPanel="True"
            ItemsSource="{Binding WorkOrdersDestinations}"
            IsReadOnly="True"
            SelectedItem="{Binding SelectedWorkorder, Mode=TwoWay}"
            RowActivated="sdkWorkorders_RowActivated">

Thanks
Rodney

[Vlad]

Hi Rodney,

 I'm not sure what is WorkOrdersDestinations in your case? Is it our VirtualQueryableCollectionView? 

All the best,
Vlad
the Telerik team

[David]

Hi Vlad,

It is an ObservableCollection.