maximum number of row allow in datagrid

[zeeshan]

I am using synchfusion datagrid with uwp app

can i know what is maximum number of row allow in grid with better performance

If I want to test with 50000 records will synchfusion performance will allow me ?

[Sivakumar R]

Hi Zeeshan, 

 

SfDataGrid can load fifty thousand records and more. Regarding performance please find the details, 

 

Scrolling performance 

SfDataGrid uses built-in UI virtualization while scrolling. So the scrolling performance is depend on the number of cells in the view and not depends number of rows. You don’t have to worry about number of records. 

 

Loading performance 

You can improve loading performance when dealing with large amount of records by enabling virtualization. Please find the details below, 

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

 

Thanks, 

Sivakumar 

[zeeshan]

thank you sir 


sir how can i used progress bar on data-grid loading event 
when data-grid loading 50000 data records from mysql database they need some time for loading data at that time user view the progress bar notification  , how can i do that

[Srinivasan Vasu]

Hi Zeeshan, 

You can show a progress ring indication of the data loading with the help of SfBusyIndicator control. Please refer the below UG and Kb link, to know more about busy indicator. 

 

https://help.syncfusion.com/uwp/sfdatagrid/styles-and-templates#showing-busy-indicator-before-loading-records 

 

https://www.syncfusion.com/kb/5351/how-to-show-the-busy-indicator-while-loading-the-data-in-the-sfdatagrid 

 

If your requirement is differ from this, please let us know with more details about your requirement. 

Regards, 

Srinivasan