Performance issue with RadGridView in Q2

3 posts, 0 answers
  1. Dirk Liebich
    Dirk Liebich avatar
    17 posts
    Member since:
    Jun 2010

    Posted 05 Aug 2010 Link to this post

    Hello,

    I just updated my code and the refrenced dlls to use the Q2 2010 release of telerik controls.

    I have a functionality incorporated which calculates values on a cell basis referring to other cells within the grid.
    I am using the cellvaluechanged-event to submit the current position and the entered value to my calculation routine.

    If grid.Rows(e.RowIndex).Cells(5).Value = "Adjusted Net Requirement (User Input)" Or grid.Rows(e.RowIndex).Cells(5).Value = "Supply Adj. Forecast (User Input)" Then
                If IsNumeric(e.Value) Then
                    _supplyLogicLayer.calculateOnTheFly(dsSupply, grid, e.RowIndex, e.ColumnIndex, e.Value)
                    '_supplyLogicLayer.calculateOnTheFly(grid, e.RowIndex, e.ColumnIndex, e.Value)
                End If
            End If


    the caluclateonthefly procedure basically grabs values from specific cells and does the calculation with them.

    Since I upgraded to the new release this procedure takes a tremendous amount of time - the Q1 release has been much faster in processing it that way. Addionaly after setting a new value to a certain cell (f.e. dr.Cells(ColumnIndex).Value = 1000) it isn't shown in the grid directly. I need to refresh it or expand and collapse a child to see the new value.

    It is probably important to know that I am using a childgridrelation within the grid.

    Let me know what you think.

    Thanks

    P.S.: We could do a netviewer remote session that you guys can see what is happening here.
  2. Dirk Liebich
    Dirk Liebich avatar
    17 posts
    Member since:
    Jun 2010

    Posted 06 Aug 2010 Link to this post

    Here is in an update on this.

    I tried to get closer on the root cause of this issue and figured out that the grid only slows down when using an hierarchical grid.

    Once I remove the hierachy relation from the grid it performance absolutly fast. Plugging the relation back in it slows down ultimativly.

    Here is my code for setting up the realtion. I do not think that there is anything wrong with it, right?

    grid.DataSource = dsSupply.Tables("SUMMARYFINAL")
     
    Dim tpl As GridViewTemplate = New GridViewTemplate
    tpl.DataSource = dsSupply.Tables("DETAILFINAL")
     
    Dim rel As GridViewRelation = New GridViewRelation(grid.MasterTemplate, tpl)
    rel.RelationName = "Summary2Detail"
     
    rel.ParentColumnNames.Add("MFG Strategy")
    rel.ParentColumnNames.Add("ZZMIN")
    rel.ParentColumnNames.Add("SourcePlant")
    rel.ParentColumnNames.Add("Material")
     
    rel.ChildColumnNames.Add("MFG Strategy")
    rel.ChildColumnNames.Add("ZZMIN")
    rel.ChildColumnNames.Add("SourcePlant")
    rel.ChildColumnNames.Add("Material")
     
    grid.MasterTemplate.Templates.Add(tpl)
    grid.Relations.Add(rel)

    Guys,
    I really appreciate your help and thoughts on it as this is an urgent issue on my end and I do not know how to proceed right now.

    Thanks
  3. UI for WinForms is Visual Studio 2017 Ready
  4. Julian Benkov
    Admin
    Julian Benkov avatar
    1135 posts

    Posted 10 Aug 2010 Link to this post

    Hi Dirk Liebich,

    Please refer to Support Ticket ID 335687.

    Kind regards,

    Julian Benkov
    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