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. Image for the cookie policy date

Slow to show - is there a better one to use?

Hi, I'm new to your suite of controls,
I've downloaded the community edition and I'm evaluating it for a new project.
In this project I will manipulate Databases for normalization purposes, so I need a Grid able to let me browse on large amount of records.

There are several grids in your suite of controls and I've tried the SfDataGrid first, but I have found it excessively slow in showing data.
Maybe it is due to my being a newbie, or maybe another grid is better suited for this purpose.

My test set of data is a collection of entities containing about 20 fields with about 9000 rows.
I load the data using a SQL Data Reader and a cycle that creates the entities. The loading process length is about 0.5 seconds,
When I show the SFDatagrid with the collection as a datasource however, About 30 seconds with UI frozen pass before the grid shows the data.

My collection is an ObservableCollection, the entity implements INotifyPropertyChanged and as a Test (without any change in showing time) instead of using
the ObservableCollection as ItemsSource, I've created a VirtualizingCollectionView that I create after loading the data using the  GridVirtualizingCollectionView method provided by your Grid Class as shown in your samples.

Seeing that there is no change in performance and UI freezing, I'd like to know if I have to create data differently or if there is a better grid control to use for this kind of data.

I add also that the Entity has an inner collection that I want to show as detail view in the grid.

Thank You in Advance
Sabrina

1 Reply

MM Muthalagu M Syncfusion Team December 9, 2015 03:14 AM UTC

Hi Sabrina,

Thanks for contacting Syncfusion Support.

A support incident to track the status of this query has been created under your account. Please log on to our support website to check for further updates


https://www.syncfusion.com/account/login?ReturnUrl=%2fsupport%2fdirecttrac%2fincidents

Please let us know if you require further assistance on this.

Thanks,
Muthalagu


Loader.
Up arrow icon