Performance issue with RadGridView in Q2

[Dirk Liebich]

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.

[Dirk Liebich]

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

[Julian Benkov]

Hi Dirk Liebich,

Please refer to Support Ticket ID 335687.

Kind regards,

Julian Benkov
the Telerik team