Iterating the Grid rows and columns takes too long

[Munish]

Hi 
I am iterating through the rows and columns of the grid view like this :
foreach (var row in radGridView.Items)
                    {
                        foreach (var column in HeaderInfo)
                        {
                            string sUniquename = uniqueNames[iColumn];
                            var boundColumn = radGridView.Columns[sUniquename] as GridViewBoundColumnBase;
                            if (boundColumn != null)
                            {                                string data = string.Format("{0}", boundColumn.GetValueForItem(row));}
                            iColumn += 1;}}
The thing is that its too slow ...for a grid with say 80k rows it is taking 5 minuted to complete this loop...I guess internally it is building up the rows internally as our grid has virtualization enabled.

Please suggest if something can be done on this.
                        
                    

[Munish]

Anybody got an idea on this ??

[Yoan]

Hi Munish,

I am afraid I can not offer a good workaround. Generally, iterating through 80K items is a time consuming operation. Could you share a bit more details for the exact scenario that you want to get ?


Regards,
Yoan
Telerik

[Munish]

I want the data as is displayed in the grid. Though , i have access to the view model ..i was preferring to read directly from the grid view as the columns might have converters , data format , data template applied. 

I tried creating a new radgrid in a seperate thread and setting all the content same as of the original grid. The time to access that local grid is less for same items...may be it is created with virtualisation as false.

[Yoan]

Hi Munish,

This is indeed strange. Can you please try the attached sample project. Do you get the same behaviour on it? It would be great if you can modify it in order to reproduce the issue and resend it back to me.


Regards,
Yoan
Telerik

[Munish]

Hi

You forgot to attach the project. Please attach the same.

[Yoan]

Hello Munish,

Please excuse me for this. I am attaching the project again. 

Regards,
Yoan
Telerik