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

WPF RadGridView Very Bad Performance when Binding

9 Answers 804 Views

GridView

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

Adnan asked on 29 Oct 2013, 09:01 AM

I use RadGridView , my business is display stock market ,so high performance is a must .
When i use Regular WPF DataGrid with MVVM Design Pattern it's working very good for my , when i replace (WPF DataGrid) with (RadGridView ) the performance became very bad , your fast response is highly appreciated , See the the Following

View Model :

using INtra_Day_EXplorer.Business_Logic; using ServiceClient.HistoricalINDEXServiceClient; using System; using System.Collections.Generic; using System.Collections.ObjectModel; using System.ComponentModel; using System.Dynamic; using System.Linq; using System.Text; using System.Windows.Documents; using System.Timers; using System.Diagnostics; using System.Threading; using System.Windows.Threading; namespace INtra_Day_EXplorer.View { class Market { #region FBD - MSeif - 29-10-2013 Properties private MarketWatch[] data = null; private Stopwatch stopWatch = new Stopwatch(); private ServiceWrapper serviceWrapper = ServiceWrapper.GetSingleton(); IEnumerable<short> IntCompanyCode { get; set; } IEnumerable<short> IntSectorCode { get; set; } List<short> CompaniesSectorsCodes { get; set; } private dynamic ExpandoTemplate { get; set; } public Boolean IsRun { get; set; } private int index { get; set; } #endregion #region FBD - MSeif - 28-10-2013 - Binding Lists for (Sector/Comapny/Comapies inside Sctors) private ObservableCollection<ExpandoObject> bindingList_CurrentCompanyWatch = new AsyncObservableCollection<ExpandoObject>(); public ObservableCollection<ExpandoObject> BindingList_CurrentCompanyWatch { get { return bindingList_CurrentCompanyWatch; } set { bindingList_CurrentCompanyWatch = value; } } private ObservableCollection<ExpandoObject> bindingList_CurrentSectorWatch = new AsyncObservableCollection<ExpandoObject>(); public ObservableCollection<ExpandoObject> BindingList_CurrentSectorWatch { get { return bindingList_CurrentSectorWatch; } set { bindingList_CurrentSectorWatch = value; } } private ObservableCollection<ExpandoObject> bindingList_CurrentSectorDetailsWatch = new AsyncObservableCollection<ExpandoObject>(); public ObservableCollection<ExpandoObject> BindingList_CurrentSectorDetailsWatch { get { return bindingList_CurrentSectorDetailsWatch; } set { bindingList_CurrentSectorDetailsWatch = value; } } #endregion /// <summary> /// FBD - MSeif - 28-10-2013 /// Get List Of Codes(Sctor/Company) and start Load data to Binding Lists (Using Backgroud thread) /// </summary> public Market() { //get companies Codes<br

>            IntCompanyCode = CompanyManager.WorkingCompanies.FindAll((CompanyInfo cinfo) => cinfo.Code <= MainData.LAST_COMPANY_CODE && cinfo.Code >= MainData.FIRST_COMPANY_CODE).Select(c => c.Code);<

br> //get sectors Codes<br

>            IntSectorCode = CompanyManager.WorkingCompanies.FindAll((CompanyInfo cinfo) => cinfo.Code <= MainData.LAST_PDS_CODE).Select(c => c.Code);<

br> //set all codes(sectors/comapnies) in one list CompaniesSectorsCodes = IntCompanyCode.ToList(); for (int i = 0; i < IntSectorCode.ToList().Count; i++) { CompaniesSectorsCodes.Add(IntSectorCode.ToList()[i]); } IsRun = true;//allow load data from WCF service // Create new instance of the thread. Thread marketWatchThrd = new Thread(new ThreadStart(RunMarketWatch)); // Set the thread to be a background one marketWatchThrd.IsBackground = true; // Start the order book requests marketWatchThrd.Start(); } /// <summary> /// FBD - MSeif - 28-10-2013 /// Get Data from WCF service and bind this data to it's List(Sectors/Companies) /// </summary> protected void RunMarketWatch() { while (IsRun) { try { //Load Data For (Sctors/Companies)<br

>                    data = serviceWrapper.ServiceReference.GetCurrentMarketWatch(CompaniesSectorsCodes.ToArray());<

br> if (data != null) { for (int i = 0; i < data.Length; i++) { // sector check if (data[i].SymbolID <= MainData.LAST_PDS_CODE) {<br

>                                ExpandoTemplate = ToDynamic(data[i]);//Cast each object(Sector) from BackEnd to be Dynamic object(ExpandoObject)<

br> index = BindingList_CurrentSectorWatch.Cast<dynamic>().Where(c => c.SymbolID == ExpandoTemplate.SymbolID).Select<dynamic, int>(x => BindingList_CurrentSectorWatch.IndexOf(x)).SingleOrDefault<int>();//Get the Index For Current Sector in the binding list <br

>                                if (IntSectorCode.ToList().Count > BindingList_CurrentSectorWatch.Count)<

br

>                                    BindingList_CurrentSectorWatch.Add(ExpandoTemplate);//add new sector to the binding list<

br> else {<br

>                                    BindingList_CurrentSectorWatch[index] = ExpandoTemplate;//Edit sector to the binding list<

br> } } else//Companies check {<br

>                                ExpandoTemplate = ToDynamic(data[i]);//Cast each object(company) from BackEnd to be Dynamic object(ExpandoObject)<

br> index = BindingList_CurrentCompanyWatch.Cast<dynamic>().Where(c => c.SymbolID == ExpandoTemplate.SymbolID).Select<dynamic, int>(x => BindingList_CurrentCompanyWatch.IndexOf(x)).SingleOrDefault<int>();//Get the Index For Current company in the binding list <br

>                                if (IntCompanyCode.ToList().Count > BindingList_CurrentCompanyWatch.Count)<

br

>                                    BindingList_CurrentCompanyWatch.Add(ExpandoTemplate);//add new company to the binding list<

br> else {<br

>                                    BindingList_CurrentCompanyWatch[index] = ExpandoTemplate;//edit new sector to the binding list<

br> } } } } } catch (Exception ex) { String str = ex.Message; // throw; } Thread.Sleep(200); } } /// <summary> /// FBD - MSeif - 28-10-2013 /// Cast any object to Dynamic object(ExpandoObject) /// </summary> /// <param name="value">Object to be Cast</param> /// <returns>Dynamic Object(Exbando Object)</returns> public static dynamic ToDynamic(object value) { IDictionary<string, object> expando = new ExpandoObject(); foreach (PropertyDescriptor property in TypeDescriptor.GetProperties(value.GetType())) expando.Add(property.Name, property.GetValue(value)); return expando as ExpandoObject; } /// <summary> /// FBD - MSeif -29-10-2013 /// Load Childs Companies to Specific sector /// </summary> /// <param name="SectorSymbolID"Sector Symbol ID></param> public void LoadChilds(short[] codes) { data = (dynamic)serviceWrapper.ServiceReference.GetCurrentMarketWatch(codes); if (data != null) { bindingList_CurrentSectorDetailsWatch = (dynamic)(data);//new ObservableCollection<MarketWatch> } } } } <div></div>

XAML :

<div><UserControl xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"  xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml" xmlns:telerik="http://schemas.telerik.com/2008/xaml/presentation" <br

>             xmlns:telerikQuickStart="clr-namespace:Telerik.Windows.Controls.QuickStart;assembly=QuickStart.Common" <

br> xmlns:local="clr-namespace:INtra_Day_EXplorer.View.UserControls" xmlns:d="http://schemas.microsoft.com/expression/blend/2008" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="d" x:Class ="INtra_Day_EXplorer.View.UserControls.ucMarketWatch" xmlns:MarketWatch="clr-namespace:INtra_Day_EXplorer.View" d:DesignWidth="535" d:DesignHeight="205"> <UserControl.Resources> <DataTemplate x:Key="StockChangeTemplate"> <local:ucStockPricePresenter StockPrice="{Binding Change}" OldStockPrice="{Binding ChangePrev}" /> </DataTemplate> <DataTemplate x:Key="StockChangePercTemplate"> <local:ucStockPricePresenter StockPrice="{Binding ChangePerc}" OldStockPrice="{Binding ChangePercPrev}" /> </DataTemplate> <DataTemplate x:Key="StockMoneyValueTemplate"> <local:ucStockPricePresenter StockPrice="{Binding MoneyValue}" OldStockPrice="{Binding MoneyValuePrev}" /> </DataTemplate> <DataTemplate x:Key="StockTradesTemplate"> <local:ucStockPricePresenter StockPrice="{Binding _trades}" OldStockPrice="{Binding TradesPrev}" /> </DataTemplate> <DataTemplate x:Key="StockTransactionPriceTemplate"> <local:ucStockPricePresenter StockPrice="{Binding _transactionPrice}" OldStockPrice="{Binding TransactionPricePrev}" /> </DataTemplate> <DataTemplate x:Key="StockVolumeTemplate"> <local:ucStockPricePresenter StockPrice="{Binding Volume}" OldStockPrice="{Binding VolumePrev}" /> </DataTemplate> <Style x:Key="DataGridContentCellCentering" TargetType="{x:Type DataGridCell}"> <Setter Property="Template"> <Setter.Value> <ControlTemplate TargetType="{x:Type DataGridCell}"> <Grid Background="{TemplateBinding Background}"> <ContentPresenter VerticalAlignment="Center" /> </Grid> </ControlTemplate> </Setter.Value> </Setter> </Style> <MarketWatch:Market x:Key="Market"></MarketWatch:Market> </UserControl.Resources> <Grid DataContext="{StaticResource Market}"> <Grid.RowDefinitions> <RowDefinition Height="20"></RowDefinition> <RowDefinition Height="21*"></RowDefinition> </Grid.RowDefinitions> <Grid Grid.Row="0"> <Grid.ColumnDefinitions> <ColumnDefinition Width="5*"/> <ColumnDefinition Width="6*"/> </Grid.ColumnDefinitions> <Canvas Grid.Column="1" > <telerik:RadComboBox x:Name="cb_View" SelectionChanged="cb_View_SelectionChanged" Width="80" Canvas.Right="10" Canvas.Top="5" Grid.Column="1" SelectedIndex="0" > <telerik:RadComboBoxItem Content="Company"/> <telerik:RadComboBoxItem Content="Sector"/> </telerik:RadComboBox> <telerik:RadComboBox x:Name="cb_Currency" Canvas.Right="95" Canvas.Top="5" Width="60" /> <TextBox Name="txt_Rate" Text="{Binding ChangePrev}" Canvas.Top="5" Canvas.Right="160" Width="60" TextChanged="txt_Rate_TextChanged" KeyDown="txt_Rate_KeyDown"></TextBox> </Canvas> </Grid> <telerik:RadGridView x:Name="grd_Result_Sector"  GroupRenderMode="Flat" <span class="Apple-tab-span" style="white-space:pre"> AutoGenerateColumns="False" <span class="Apple-tab-span" style="white-space:pre"> CanUserFreezeColumns="True" CanUserDeleteRows="True" CanUserInsertRows="False" IsReadOnly ="True" Grid.Row="1" <span class="Apple-tab-span" style="white-space:pre"> RowIndicatorVisibility="Collapsed" BorderThickness="1" BorderBrush="#3090C7" Visibility="Hidden" ItemsSource="{Binding BindingList_CurrentSectorWatch}" <span class="Apple-tab-span" style="white-space:pre"> IsFilteringAllowed="True" Margin="1,10,1,1" ShowGroupPanel="False" AlternationCount="2"> <telerik:RadGridView.Columns> <telerik:GridViewDataColumn Header="Name" DataMemberBinding="{Binding CompanyName}" Width="*" /> <telerik:GridViewDataColumn Header="Code" DataMemberBinding="{Binding SymbolID,StringFormat={}{0:0.####}}" Width="*" /> <telerik:GridViewDataColumn Header="Change" CellTemplate="{StaticResource StockChangeTemplate}" DataMemberBinding="{Binding Change}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Change Percentage" CellTemplate="{StaticResource StockChangePercTemplate}" DataMemberBinding="{Binding ChangePerc}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Money Value" CellTemplate="{StaticResource StockMoneyValueTemplate}" DataMemberBinding="{Binding MoneyValue}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Trades" CellTemplate="{StaticResource StockTradesTemplate}" DataMemberBinding="{Binding _trades}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Transaction Price" CellTemplate="{StaticResource StockTransactionPriceTemplate}" DataMemberBinding="{Binding _transactionPrice}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Volume" CellTemplate="{StaticResource StockVolumeTemplate}" DataMemberBinding="{Binding Volume}" DataFormatString="{}{0:C}" Width="*" /> </telerik:RadGridView.Columns> </telerik:RadGridView> <telerik:RadGridView x:Name="grd_Result_Company" GroupRenderMode="Flat" <span class="Apple-tab-span" style="white-space:pre"> AutoGenerateColumns="False" <span class="Apple-tab-span" style="white-space:pre"> CanUserFreezeColumns="True" CanUserDeleteRows="True" CanUserInsertRows="False" IsReadOnly ="True" Grid.Row="1" <span class="Apple-tab-span" style="white-space:pre"> RowIndicatorVisibility="Collapsed" BorderThickness="1" BorderBrush="#3090C7" Visibility="Visible" ItemsSource="{Binding BindingList_CurrentCompanyWatch}" <span class="Apple-tab-span" style="white-space:pre"> IsFilteringAllowed="True" Margin="1,10,1,1" ShowGroupPanel="False" AlternationCount="2"> <telerik:RadGridView.Columns>   <telerik:GridViewDataColumn Header="Code" DataMemberBinding="{Binding SymbolID}" Width="*" /> <telerik:GridViewDataColumn Header="Change" CellTemplate="{StaticResource StockChangeTemplate}" DataMemberBinding="{Binding Change}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Change Percentage" CellTemplate="{StaticResource StockChangePercTemplate}" DataMemberBinding="{Binding ChangePerc}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Money Value" CellTemplate="{StaticResource StockMoneyValueTemplate}" DataMemberBinding="{Binding MoneyValue}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Trades" CellTemplate="{StaticResource StockTradesTemplate}" DataMemberBinding="{Binding _trades}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Transaction Price" CellTemplate="{StaticResource StockTransactionPriceTemplate}" DataMemberBinding="{Binding _transactionPrice}" DataFormatString="{}{0:C}" Width="*" /> <telerik:GridViewDataColumn Header="Volume" CellTemplate="{StaticResource StockVolumeTemplate}" DataMemberBinding="{Binding Volume}" DataFormatString="{}{0:C}" Width="*" /> </telerik:RadGridView.Columns> </telerik:RadGridView> </Grid> </UserControl> <div> </div> </div>

In Code Behind :
I Only Declare Market Object :

Market objMarket = new Market();

9 Answers, 1 is accepted

answered on 09 May 2016, 04:02 PM

Hi,

I'm having serious performance problems with RadGridView.

I havemy User Control with the following Content, and my DataContext is a ViewModel Class with one member called DataItem. This element has one property Nodes that is an ObservableCollection<Nodes> and each node has a property called Signals that is an ObservableCollection<Signal>. Just few properties inside both as you can see from the following code.

I need to navigate and if necessary modify my nodes and their signals, so I'm trying to use RadGridView with Hierarchical approach. Each node has maximum 500/600 signals but also with 30 signals I have performace problems (5/6 seconds to load 500 signals) and when I try to scroll signals the control is really slow...

What can I do to improve performances? Any suggestion?

<telerik:RadBusyIndicator IsBusy="{Binding OperationOngoing}">

<Grid>

<Grid.RowDefinitions>

<RowDefinition Height="Auto" />

<RowDefinition />

</Grid.RowDefinitions>

<Border Grid.Row="2" Margin="5">

<telerik:RadTabControl>

<telerik:RadTabItem Header="Progettazione">

<telerik:RadTabControl>

<telerik:RadTabItem Header="Nodi">

<Grid>

<telerik:RadGridView x:Name="radgrdNodes" AutoGenerateColumns="False" ValidatesOnDataErrors="InEditMode"

IsReadOnly="{Binding IsReadOnly}" ItemsSource="{Binding DataItem.DesignKit.Nodes}"

CanUserInsertRows="True" CanUserFreezeColumns="True" NewRowPosition="Top"

CanUserResizeRows="False" AddingNewDataItem="OnRadGrdNodes_AddingNewDataItem" SelectionUnit="FullRow" SelectionMode="Single"

CanUserDeleteRows="True" RowDetailsVisibilityMode="VisibleWhenSelected">

<telerik:RadGridView.Columns>

<telerik:GridViewDataColumn DataMemberBinding="{Binding Name}" Header="Nome"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding Description}" Header="Descrizione"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding Number}" Header="Numero"/>

</telerik:RadGridView.Columns>

<telerik:RadGridView.RowDetailsTemplate>

<DataTemplate>

<telerik:RadGridView x:Name="radgrdSignals" ValidatesOnDataErrors="InEditMode"

ItemsSource="{Binding Signals}"

AutoGenerateColumns="False" CanUserInsertRows="True" CanUserFreezeColumns="True" NewRowPosition="Top"

CanUserResizeRows="False" AddingNewDataItem="OnRadGrdSignals_AddingNewDataItem" SelectionMode="Extended"

CanUserDeleteRows="True">

<telerik:RadGridView.Columns>

<telerik:GridViewCheckBoxColumn DataMemberBinding="{Binding IsSymbol}" Header="Simbolo"/>

<telerik:GridViewDataColumn DataMemberBinding="{Binding Name}" Header="Nome"/>

</telerik:RadGridView.Columns>

</telerik:RadGridView>

</DataTemplate>

</telerik:RadGridView.RowDetailsTemplate>

</telerik:RadGridView>

</Grid>

</telerik:RadTabItem>

</telerik:RadTabControl>

</telerik:RadTabItem>

</telerik:RadTabControl>

</Border>

</Grid>

</telerik:RadBusyIndicator>

What can I do to improve performances? Any suggestion? Regards

answered on 11 May 2016, 11:25 AM

TelerikWpfApp10.zip

Hi Daniele,

I tried reproducing your setup and the issue you are experiencing but could not observe such degraded performance or delayed scrolling. What is the control version that you are using at your end? I have attached a sample project to my reply. Can you please modify it so that the undesired behavior can be observed and raise a ticket so we can further investigate the exact scenario?

Generally, I suggest you go through the Tips and Tricks article on different approaches for maximizing the performance of RadGridView.

Regards,
Stefan Nenchev
Telerik

Do you need help with upgrading your AJAX, WPF or WinForms project? Check the Telerik API Analyzer and share your thoughts.

answered on 15 Aug 2016, 05:27 PM

Hi Stefan,

In my specific case, I eventually determined that the RadGridView instance only exhibited this problem when contained within a RadExpander.

In the right circumstances, the RadGridView instance in question would not only perform badly, but it would lock up the UI and continually consume memory (would easily reach GBs of RAM usage if I let it run).

The layout of my application is rather complex, with the user control containing the RadGridView instance being switched out dynamically (via ContentPresenter bound to the selected item of a RadTreeView). I eventually found that either setting the height of the RadGridView or removing the surrounding RadExpander would resolve the problem, so I expect that the control gets caught in some type of measurement/rendering loop.

- Mark R.