We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

How to improve performance when loading grid with more number of records and 1000+ columns?

Platform: WPF |
Control: SfDataGrid |
Published Date: June 6, 2017 |
Last Revised Date: June 7, 2017

Loading performance of SfDataGrid can be improved in following ways to provide better performance when loading millions of records with 1000+ columns,

  1. Set EnableDataVirtualization as true for improving loading and data operations performance, where DataGrid will get loaded and process the data immediately regardless of number of records.

https://help.syncfusion.com/wpf/sfdatagrid/data-virtualization

  1. Set UseDrawing property for improving loading and scrolling performance, where SfDataGrid cells drawn instead of loading TextBlock. This option can be used when you are loading more number of cells in View. For examples, you can use this when view displays 40 rows and more than 30 columns.

https://help.syncfusion.com/wpf/sfdatagrid/performance#improving-loading-and-scrolling-performance-using-lightweighttemplate

 

For more details about performance, you can refer below documentation link,

https://help.syncfusion.com/wpf/sfdatagrid/performance

 

For your reference, we have attached the sample in below location which loaded with 1000 columns.

Sample Link:

WPF

2X faster development

The ultimate WPF UI toolkit to boost your development speed.
ADD COMMENT
You must log in to leave a comment

Please sign in to access our KB

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon