This is a migrated thread and some comments may be shown as answers.

radgridview slow databinding

17 Answers 295 Views

GridView

This is a migrated thread and some comments may be shown as answers.

joao rodrigues asked on 28 Apr 2010, 05:23 PM

Hi,

I'm evaluating silverlight controls comparing telerik and others and my major concern has to be with the gridview component since in Bussiness Apps is a fundamental component.

I'm using the radgridview in three screnarios for loading 2000 recs x 15 cols using RIA services :
1 - xaml only :

<my1:RadGridView Name="rgv1" AutoExpandGroups="True" ItemsSource="{Binding Data, ElementName=dataDomainDataSource}" />

2- xaml + Code (bind after load)

<my1:RadGridView Name="RadGrid1" AutoExpandGroups="True"/>

CFDomainContext ctx = new CFDomainContext();

ctx.Load(ctx.GetVEntitiesQuery());

private void Button_Click_3(object sender, System.Windows.RoutedEventArgs e)

{

RadGrid1.ItemsSource = ctx.VEntities;

}

3 - xaml + Code (databind):

my1:RadGridView Name="RadGrid1" AutoExpandGroups="True"

ItemsSource="{Binding Path=VEntities}"/>

CFDomainContext ctx = new CFDomainContext();

this

.DataContext = ctx;

ctx.Load(ctx.GetVEntitiesQuery());

The first scenario takes about 4 secs, what is good.

The second scenario takes about 2 seconds to perform the load (RIA) and less than 2 seconds to show the data (RadGrid1.ItemsSource = ctx.VEntities;) what is excelent!

The third scenario is my big problem, the system takes more than 15 Seconds to perform the load...

My first conclusion was "OK, I made a mistake" (and I still think that :) but when i perform the same test with other grid component that I'm evaluating also (infragistics) the process (third scenario) takes about 5 seconds...

Can you help me with that ?

Thank you,
Joao

17 Answers, 1 is accepted

answered on 30 Apr 2010, 10:38 AM

Thank you for your response Vlad.

Your example reflects almost exacly my 1st scenario and the performance is in fact great.

My problem is the 3rd scenario:

<my1:RadGridView Name="RadGrid1" AutoExpandGroups="True" ItemsSource="{Binding Path=VEntities}"/>
---
CFDomainContext ctx = new CFDomainContext();

this.DataContext = ctx;

ctx.Load(ctx.GetVEntitiesQuery());
---
Here I bound the ItemsSource to an EntitySet and on load event I call the Load method to fill the entity set.
I don't know the RadGrid internals but I can imagine that it is doing some processing every time an record is added to EntitySet since the entityset bound to grid ...Maybe I'm wrong...

Any Ideas ?

Accepted

answered on 30 Apr 2010, 01:43 PM

silverlightapplication1.zip

Hi Joao,

Indeed you are right. I've modified your project to illustrate you how to overcome this. You can find the project attached.

Don't hesitate to contact us if you have other questions.

Best wishes,
Vlad
the Telerik team

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 Public Issue Tracking system and vote to affect the priority of the items.

answered on 04 Oct 2010, 06:53 PM

I am evaluating Grid now and I have the same problem. We are going to move from Silverlight Toolkit grid (which is free, fast, and stable, but seriously lacks features) to some commercial grid.

Grid is bound to EntitySet with ~1000 records, and browser freezes for 4 seconds when data finishes loading (and I have 3.2GHz Core 2 Duo. Our customers use notebooks with slower processors). This is not an issue with Toolkit grid and Syncfusion grid.

Situation is many times worse if I have pre-defined GroupDescriptor.

I see that solution is to bind grid AFTER data has been loaded, but this looks like a bad workaround (EtitySet implements INotifyCollectionChanged, why should I care) and not always easy to do (I have multiple queries loading and tracking all of them would be a pain).

This thing is the only concern about Telerik grid by far; other things look perfect. Is there any chance that it will be fixed?

answered on 05 Oct 2010, 12:21 PM

Hello Pavel,

I've checked the project attached to the support ticket however I'm unable to run it since your are using old version (not the official one) of RIA Services. I've noticed however that grids in your case are inside StackPanel which will measure the grid with infinity height .In this case the grid virtualization will be off and all rows will be created at once. If you to get more info about the performance of RadGridView and RadDataPager bound to WCF RIA Services you can check my blog post.

All the best,
Vlad
the Telerik team

answered on 12 Jun 2013, 02:47 PM

Hi there,
i have a similar problem with slow data binding in a radgridview :/

i have a page with two gridviews. one is collapsed, one is visible. in each grid are ~25 - 30 Rows and ~14 Colums!

i have 2 viewmodels for each grid and i`m binding a static ObservableCollection with custom Itemclasses(~14 properties, just strings, few datetimes, few ints) on the itemsources.

to render the page with all 14 columns, it takes ~2secounds...with one column its fast!

its a blank gridview with autogeneratedcolums=true.

some hinds?

Greetings

PageConstructor:

if (retailersViewModel == null)

{

retailersViewModel = this.Resources["retailersViewModelView"] as RetailersViewModel;

retailerDataGrid.ItemsSource = retailersViewModel.RetailersViewCollection;

}




<telerik:RadGridView  x:Name="retailerDataGrid"
                      Visibility="Visibile"
                      AutoGenerateColumns="True"
                      Margin="0,50,0,50"  >

Product Bundles

DevCraft

Web

Mobile

Document Management

Desktop

Reporting & Mocking

Automated Testing

CMS

UI/UX Tools

Debugging

Free Tools

Support and Learning

radgridview slow databinding

17 Answers, 1 is accepted