Performance Improvement in RadGridView

[Nishan]

Hi
I am binding 800000 records to the radgridvew control and one way of doing is as follows as normally.

List<Company> companyList = new List<Company>();
for (int i = 0; i < 800000; i++)
{
    companyList.Add(
        new Company()
        {
            Id = i,
            Name = "test name " + i,
            Address = "test address " + i,
            Revenue = 88888888,
            BusinessAres = "test area " + i,
        });
}
radGridView1.ItemsSource = companyList;

So with Q3 I try to optimize the performance like below.

List<Company> companyList = new List<Company>();
for (int i = 0; i < 800000; i++)
{
    companyList.Add(
        new Company()
        {
            Id = i,
            Name = "test name " + i,
            Address = "test address " + i,
            Revenue = 88888888,
            BusinessAres = "test area " + i,
        });
}

var viewList = new VirtualQueryableCollectionView(companyList) { LoadSize = 10 };
radGridView1.DataContext= viewList;

my xaml code is like this

<Window x:Class="WpfApplication1.MainWindow"
        xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
        xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"
        Title="MainWindow" Height="350" Width="525" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" Loaded="Window_Loaded">
    <Grid>
        <telerik:RadGridView HorizontalAlignment="Stretch"
                             Margin="0,43,0,0"
                             Name="radGridView1"
                             ItemsSource="{Binding}"

                             VerticalAlignment="Stretch" />
        <Button Content="Button" Height="23" HorizontalAlignment="Left" Margin="23,12,0,0" Name="button1" VerticalAlignment="Top" Width="75" Click="button1_Click" />
    </Grid>
</Window>

this increases the rendering speed little but I am still looking something better. So if anyone can suggest a way please reply. Thanks in advance.

Nishan
 

[Milan]

Hello Nishan,

Could you please elaborate on the performance problems that you are currently facing? Are you bothered by a slow initial load time, slow vertical or horizontal scrolling?

Greetings,
Milan
the Telerik team

[Nishan]

Thank you very much for the quick response. Actually I am bothered by the slow initial load time. It takes about 1-2 seconds to load the data but I want to make it super fast. Also I don't want paging. Thanks.

[Milan]

Hi Nishan,

Have you tried to generate the data before you actually assign it as ItemsSource. Data generation for 800000 item takes some time and it might be causing the slowdown. You can try generating the data in the constructor of your page and to assign the ItemsSource of button click. 

Could you please try that and tell me if you see and improvement.

All the best,
Milan
the Telerik team

[Sam Ur]

Actually I'm having the same issue, I followed the ORM - WPF quickstart guide and even in that sample gride takes a sec. or two to load, so when I'm using a model that populates more data wpf grid really takes a few sec (1-3) to load. I tried to populate data in constructor before I load them but the result (time wise) was the same.

EDIT:
 When I'm using RadGridView in tab control it also works very slow - because i guess it re-renders everytime i change tab.

P.S.
I made a console app. just to see if getting data takes so long - but it doesn't.

[Milan]

Hi Sam Ur,

Could you please take a look at this help topic which contains some tips that might help you improve performance. 

Regards,
Milan
the Telerik team

[Sam Ur]

Thank you I'll look into it.

[Sam Ur]

Best thing i found to improve performance was the use of RadDataPager - now performance is not pefect but still much better.
Slight issue i had was still when RadGridView is used in RadTabItem - everytime that item looses focus and regains it - data gets re-loaded, that downgraded performance a bit - if you don't use the necessary steps to avoid this issue.

Milan thnx again 4 the advice where to look performance tricks.