Grid with large number of rows and columns

60 posts, 2 answers
  1. amit
    amit avatar
    21 posts
    Member since:
    Nov 2007

    Posted 28 Jun 2010 Link to this post

    Hi,

    I am evaluating Telerik Silverlight GridView control. The control almost works fine so far. Now I am testing it with large number of rows and columns. I am seeing following behaviors that I didn’t expect. I have enabled row and column virtualization, template columns and large data set.

    1) Horizontal scrolling is slower than vertical scrolling.

    2) Grid doesn’t handle large number of columns as well as it handles large number of rows. For an example, grid with 2000 rows X 100 columns performs better than grid with 100 rows X 2000 columns. Grid with 2000 columns loads/scrolls slower. As numbers of visible cells are same, I was hoping that both grids should perform same.

    3) As number of columns is increased, grid’s performance degrades. I was hoping that grid would perform for 2000 columns as same as it was performing for 100 columns. That’s because grid only renders visible area which is same for both cases.

    It is by design? Is there any way to overcome these issues? Will they be taken care in future release?

    Thank you,
    Amit

  2. Stefan Dobrev
    Admin
    Stefan Dobrev avatar
    790 posts

    Posted 30 Jun 2010 Link to this post

    Hello amit,

    Can you please send us your example project that illustrates this poor performance? Having it we will be able to suggest you ways to optimize your scenario.

    Regards,
    Stefan Dobrev
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  3. DevCraft banner
  4. amit
    amit avatar
    21 posts
    Member since:
    Nov 2007

    Posted 01 Jul 2010 Link to this post

    Unfortunately, I couldn't upload my sample project, as forum only allows to upload pictures (< 2MB total). Is there anything else I can do?

    Also, can you please provide of answer of following questions?
    1) Dees number of columns/rows affect how fast grid get loaded?
    2) Does number of column/rows affect scrolling performance?

    Thank you.
  5. Hristo
    Admin
    Hristo avatar
    408 posts

    Posted 02 Jul 2010 Link to this post

    Hello amit,

    Please refer to the response in your other thread.

    As for the RadGrid performance you can refer to this online example how it handles 50mln cells.

    Sincerely yours,
    Hristo
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  6. Frank Wanicka
    Frank Wanicka avatar
    20 posts
    Member since:
    Jun 2010

    Posted 20 Aug 2010 Link to this post

    I am having the same issue, and you can actually see it in your 50 million cell example. The horizontal scrolling is much slower than the vertical. I have about 150 columns of varying data types. Some have long strings in them (250-500 characters). Horizontal scrolling is painfully slow with only 25 rows. I've tried the column and row virtualization on and off. Here is the current code:

     <telerik:RadGridView x:Name="ListingGrid"
                                 ItemsSource="{Binding Listings, Mode=OneWay}"
                                 AutoGenerateColumns="True"
                                 EnableColumnVirtualization="True"
                                 EnableRowVirtualization="True"
                                 IsReadOnly="True">

    Before you ask, no I don't have a sample project for you. It should be simple for you to create one. Take your 50 million cell example and replace the numbers with long strings.
  7. Hristo
    Admin
    Hristo avatar
    408 posts

    Posted 27 Aug 2010 Link to this post

    Hello Frank Wanicka,

    We can confirm that in such extreme cases the performance of RadGridView suffers. Our engineers are putting a lot of efforts in investigating the problem and searching for a solution.

    Thank you for your patience and understanding!

    Sincerely yours,
    Hristo
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  8. amit
    amit avatar
    21 posts
    Member since:
    Nov 2007

    Posted 01 Sep 2010 Link to this post

    Hi Hristo,

    When can we expect fix of the performance issue?

    Thank you,
    Amit
  9. Hristo
    Admin
    Hristo avatar
    408 posts

    Posted 02 Sep 2010 Link to this post

    Hi amit,

    Handling such extremely large data sets is not a trivial task and we'll need more time for investigation and finding the right solution. This is why for the time being we cannot commit to any specific date or release.

    Regards,
    Hristo
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  10. Frank Wanicka
    Frank Wanicka avatar
    20 posts
    Member since:
    Jun 2010

    Posted 02 Sep 2010 Link to this post

    Just to be clear, we're not talking about a huge dataset. This happens with 10 rows and 150 columns. It performs fine with 10000 rows and 10 columns, but not 10 rows and 150 columns.
  11. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 02 Sep 2010 Link to this post

    Hello,

     I've attached an example project with grid bound to collection of 10 items and 150 columns with long strings. Let me know what you think about the grid horizontal scroll performance.

    Best wishes,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  12. Frank Wanicka
    Frank Wanicka avatar
    20 posts
    Member since:
    Jun 2010

    Posted 02 Sep 2010 Link to this post

    Honestly, it is a bit laggy. Are you not seeing the lag?

    It's nowhere near as smooth as when scrolling vertically with a large number of rows and 10 columns with small amounts of data. And in my app where I am databinding to a Ria Services EntitySet with a variety of field types (decimal, integer, boolean, string (with a couple of very long string fields), etc.), it is even worse. It's not unusable, but the difference in horizontal and vertical scrolling is very noticeable IMO.

    FYI, my hardware is Intel Core2 Duo 2 GHz with 4 gigs of RAM running Windows 7 64 bit Ultimate. It's not state of the art, but it's better than a lot of my potential customer's machines.
  13. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 02 Sep 2010 Link to this post

    Hello,

     You can optimize the scrolling if you specify explicitly width for the columns - you can set for example ColumnWidth="150" for the grid.

    Best wishes,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  14. Frank Wanicka
    Frank Wanicka avatar
    20 posts
    Member since:
    Jun 2010

    Posted 02 Sep 2010 Link to this post

    Ok. That's just tough to do when you have no idea how long the text will be. I can do that for the numeric columns. Hopefully, that will improve things somewhat.
  15. Jarred Froman
    Jarred Froman avatar
    57 posts
    Member since:
    Aug 2008

    Posted 30 Sep 2010 Link to this post

    We have been experiencing this same issue for quite some time now.  We've tried all these same recommendations to no avail.  Anything you can do to expedite this would be greatly appreciated!

    Thanks,
    -Jarred Froman
  16. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 01 Oct 2010 Link to this post

    Hello Jarred,

     How many columns/rows you have in your grid? More info about your scenario will be appreciated. 

    Kind regards,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  17. amit
    amit avatar
    21 posts
    Member since:
    Nov 2007

    Posted 01 Oct 2010 Link to this post

    I also tried recommendations. But it really doesn’t improve performance. It is pressing issue for me. Slower scrolling is annoying user many times; especially when there are lots of data in the grid. I want to use Silverlight grid for better performance that asp.net grid. Slower scrolling kind of hides its performance advantage when there are lots of columns in the grid. I can have easily 30+ columns in the grid. Anything you can do to expedite this would be really appreciated.  Also, if you can provide approximate date when it will be fixed, it will be really helpful.
  18. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 04 Oct 2010 Link to this post

    Hi,

     Have you tried this demo? The grid is bound collection of 500000 items with 100 properties. 

    Best wishes,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  19. amit
    amit avatar
    21 posts
    Member since:
    Nov 2007

    Posted 04 Oct 2010 Link to this post

    Yes, I have seen it. You can see there horizontal scrolling is not as good as vertical scrolling. Theoretically, both scrolling renders equal amount of new cells. So both scrolling should be comparable. Also, 50M cells example works faster because grid window is very small than browser window (grid has to render less cells when grid window is smaller). Grid covers 90%+ screen real estate on the page for me. So I see more performance degradation in both vertical and horizontal scrolling. Vertical scrolling is still acceptable. But horizontal scrolling is slow. I also use custom columns. But I don't think it is making much performance impact (I am already suggestions for custom columns like avoid  binding if not necessary from Telerik support).
  20. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 04 Oct 2010 Link to this post

    Hello,

    Do you cache cell Content with your custom columns?  This can improve the performance greatly - for example if you have TextBlock you can change only TextBlock Text instead creating new instance every time. 

    Sincerely yours,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  21. Doug
    Doug avatar
    4 posts
    Member since:
    Oct 2010

    Posted 07 Oct 2010 Link to this post

    Im having a big problem with this. Im testing with around 1000 rows and around 30-60 columns and if I turn on column virtualization then horizontal scrolling is very slow and jerky. If I turn off column virtualization the scrolling is fine but then any refresh of the data takes around 4 seconds to update the UI. With the column virtualization on it only takes less than 1 second.

    I have a sample project so but cant see how to submit it as it only allows images to be uploaded.

    Regards,
    Doug Rees
    Polo Ralph Lauren.
  22. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 07 Oct 2010 Link to this post

    Hello Doug,

     Please open support ticket and attach the project. 

    Kind regards,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  23. Doug
    Doug avatar
    4 posts
    Member since:
    Oct 2010

    Posted 07 Oct 2010 Link to this post

    Ok Vlad, have submitted ticket 355206

    Regards,
    Doug Rees
  24. The Dev
    The Dev avatar
    3 posts
    Member since:
    Nov 2009

    Posted 14 Oct 2010 Link to this post

    I'm having exactly the same issues as Doug, Frank and Amit.
    They explain it perfectly, horizontal scrolling is very laggy with variable size columns and "longish" strings, I'm talking less than than 50 character strings.
    I'm seeing this with around 30 rows and 20 columns, nothing special about the columns, some checkbox's as AutoGenerateColumns is set to true.

    The project I am working on has been specifically commissioned to improve performance for the user, I was hoping the Telrik grid would help here.
    It loads and scrolls vertical pretty well, but horizontal scrolling is, well..... laggy and a poor experience.

    Any news on a potential fix ?

    Thanks

    D
  25. Answer
    Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 15 Oct 2010 Link to this post

    Hi Dave,

     Yesterday we fixed serious performance issue related to horizontal scrolling and the fix will be part of our upcoming latest build Today. Please check our new build (will be available later Today) and let us know if you still have such problems.  

    Kind regards,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  26. Doug
    Doug avatar
    4 posts
    Member since:
    Oct 2010

    Posted 15 Oct 2010 Link to this post

    Vlad please post on here when new build is available. I just checked and currently it looks like 08 October is latest at the moment.

    Thanks,
    Doug
  27. Frank Wanicka
    Frank Wanicka avatar
    4 posts
    Member since:
    Jan 2006

    Posted 16 Oct 2010 Link to this post

    Is there a new internal build? I'm not seeing it.
  28. Nicolas
    Nicolas avatar
    57 posts
    Member since:
    Dec 2008

    Posted 18 Oct 2010 Link to this post

    I am also looking forward a new build, for this and the new VirtualQueryableCollectionView which will hopefully be included in it. 
    Can you please let us know when we can expect a newest build?
  29. Answer
    Hristo
    Admin
    Hristo avatar
    408 posts

    Posted 18 Oct 2010 Link to this post

    Hi Nicolas,

    Our latest internal build with version 2010.2.1018 is ready for download under Your Accounts.

    @ Nicolas: Our new VirtualQueryableCollectionView will be part of our Q3 2010 Beta release (not in the latest internal build) which is expected later today.

    Regards,
    Hristo
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
  30. Nicolas
    Nicolas avatar
    57 posts
    Member since:
    Dec 2008

    Posted 18 Oct 2010 Link to this post

    @Hristo 

    Thank you, that is good news. I have been able to try the internal and the horizontal scrollbar performs much better indeed (still slower than the vertical scrollbar but still much better than before, where it was just unusable).
    Unfortunately, using the internal build some features such as row insertion and edition do not work anymore so we'll wait until an official release.
    Where will the beta be downloadable? I've searched high and low and could not find a page with betas of controls to download.
  31. Vlad
    Admin
    Vlad avatar
    11100 posts

    Posted 18 Oct 2010 Link to this post

    Hello Nicolas,

     Can you send us small example application (via support ticket) demonstrating your scenario and these problems with rows insert/edit? Unfortunately we didn't manage to upload our beta Friday and we will do our best to do this Today. 

    Sincerely yours,
    Vlad
    the Telerik team
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items
Back to Top
DevCraft banner