|120859||Oct 23,2015 08:11 AM UTC||Oct 28,2015 07:12 AM UTC||WPF||3|
In above sample, we have loaded nearly 30000 records with 20 columns in our SfDataGrid. In this sample we are not able to reproduce the your reported “loading takes MINUTES for few hundred items or thousands” issue.
We need more information on your query and could you please share the below details to us. It will be helpful for us to analyze further.
1. Could you please confirm whether you are using any Cellstyles or applying style using styleselectors?
2. And please confirm whether you are using Triggers to set cell value in your application?
3. Could please share that when you getting performance issue whether while switching different tabs or else while loading SfDataGrid initially?
Normally if we use ColumnSizer as “Auto” in SfDataGrid, column width will be calculated based on cell value of particular column and header text. If the cell value length is greater than header text length, cell value length will be set to width of column or else header text length will be set. This is the behavior of our Auto ColumnSizer in SfDataGrid. Hence if you loading more number of records with ColumnSizer as ‘Auto’ in SfDataGrid, it will take some time to load due to the behavior of ColumnSizer. So we suggest you to use ColumnSizer as “Star” or “SizeToHeader” or “None” instead of “Auto” or “AutoWithLastColumnFill” or “SizeToCell”.
Please find the following UG link to know more about Columnsizer,
We are also suggest to use DataVirtualization for increasing the loading performance and please find the UG link as below,
UG Link: http://help.syncfusion.com/wpf/sfdatagrid/data-virtualization
We are recommend you to use the “SfDataGrid.Dispose()” method for release the memory used by SfDataGrid.
Could you please try out the above ways to improve the loading performance in your side and please update the above requested details if you still facing the issue.
Please let us know if you have any other queries.
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.