Hi
I am facing some performance issue after setting summary values to column.I takes 2-3 seconds to scroll horizontal or vertical.I have 500 unbounded columns and 50 rows(10 groupby rows) and 80 visible columns in area.I have added custom summary calculator to columns.
The thing which i want to achieve is to show different colors and text in each groupby row means one row with different color in each column(see attachment).I have used ICustomSummary calculator.I am returning just a string in EndCustomSummary method.I have tried to improve the performance by setting same customsummarycalculator in each column but it is still very slow.
Hi,
How many summaries do you have? One for each column?
If you have 500 columns, each with it's own custom summary calculator, then I'm not surprised you are experiencing some performance issues. In a case like this, the grid will have to iterate over the rows collection 500 times every time the summary is calculated. I don't see any way around that.
But... if you can post a small sample project demonstrating the behavior, I would be happy to take a look at it and see if I can find some way to improve the performance. Without a sample, though, there are just too many unknowns.
Hi I have attached the sample within.You can see the problem when groupby rows are expanded and user want to scroll vertical.So it takes time to expand row and also take time to scroll vertical and horizontal.
Another question As you can see in sample the height of groupby column is increased as SummaryDisplayStyle is set to Summarycells.You can see when you press remove summary button in sample the height is decreased.I think it is due to GroupByRowDescriptionMaskSo is it possible that groupby row height donot increase while applying summary cells to it.