Filtering slow when AggregateFunction is used

[Siddhant]

When i am using the aggregate function the grouping an filtering slows down quite it bit. Is there anyway that the performance can be achieved so that it doesnt slow down as much it is currently. Also it becomes unresponsive during this period.

PS: The aggregate function is a complicated one

var aggregate = new AggregateFunction<ResourceAllocationBE, double>
{
AggregationExpression = models => models.Where(x => x.flag != "Forecast").Select(x => x.period.Where(y => y.date == currentDate).Select(d => d.allocation).Sum()).Sum()/100
,Caption = ""
};

[Rossen Hristov]

Hi,

Your aggregate function is indeed quite complex and unfortunately we cannot make the Silverlight run-time execute it faster. We simply use LINQ to do filtering, sorting and grouping and if the Silverlight run-time takes a certain amount of time to execute a such LINQ query with such an aggregation in-memory, then we can't possibly make this run faster.

Greetings,
Rossen Hristov
the Telerik team

[Siddhant]

Is there anyway to make the AggregateFunction less complicated and faster in execution