Hello,
I have few custom summary operands on my grid. These summary operands span across some 15 or so columns and ~100K records. These operands are a bottle neck when filtering, sorting grouping etc...
My plan was to defer the summary calculations after filtering, sorting, grouping ....
I have the SummaryExecution="AfterFilteringAndPaging"flag set and I don't have paging turned on but short story this doesn't have any effect.
Any suggestions?
Thanks
Hello Sint,
I am just checking if my last reply was helpful for you.
If you require any further assistance, please do not hesitate to ask.
Sincerely,
I have attached a sample application that may be useful.
I am using custom summaries.
The problem is that these summaries execute while filtering and while sorting. I just need to defer the execution of these custom summaries to after the grid filtered or sorted and rows are updated.
When summaries are executing while filtering / sorting it slows down the filtering and sorting.
I am just checking your progress on the issue.
If you have any other questions on the matter, please feel free to ask.
Thank you for your post.
The SummaryExecution property defines the scope of the data on which a summary operation is performed rather than deferring the actual execution.
Setting the property to AfterFilteringAndPaging results in summary operations executed on the already filtered and paged data.
Setting the property to PriorToFilteringAndPaging results in summary operations executed on the whole set of data neglecting the filters and paging.
There should be some improvement in performance only if the data is already filtered/paged and the SummaryExecution is set to “AfterFilteringAndPaging” because the summary operations are executed on a smaller set of data items (filtered data on a page).
You can also specify the scope of the summary using the SummaryScope property to ChildBand – each child band of data will be summed independently or ColumnLayout – all rows sharing a ColumnLayout will be summed together.
Probably you can optimize the performance by creating custom summaries and implementing custom queries. See the following topic how to create such summaries: http://help.infragistics.com/doc/Silverlight/2015.1/CLR4.0/?page=xamGrid_Create_a_Custom_Summary.html
Please let me know if this helps you or you have further questions on this matter.