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 Mike,
I'd like to follow up on this issue as we are seeing the same issue with 2013 Infragistics UltraGrid.
Here is my question:
Why are the summary cells re-calculated every time they are scrolled into view, even for a read-only grid? Is there a setting to tell grid to calc once during initial load and don't re-calc during scrolling?
Thanks
Steve
Hi,
I ran your sample through the Ant Performance profiler and it looks like I was right. When you scroll and some new summary cells come into view, the grid has to loop through all of the rows that apply to that summary. With so many summaries, this results in something like 280,000 iterations of a loop which gets the summary value.
I don't see any way around this. This many summaries is just not going to be performant.
avlindia said:So is it possible that groupby row height donot increase while applying summary cells to it.
I' not sure exactly what you want here. There's no way to stop the GroupByRow from increasing in height to accommodate the summaries. If there was a way, it would end up clipping the summaries and you would not be able to see them clearly.
You can increase the height of the GroupByRow when there is no summary by setting it's Height property, of course. At least then the height would be consistent whether there is a summary or not.
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.
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.