Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Improve Aggregation Performance

Hi all,

I have a table containing 20mils rows of data. To improve the performance, I decided to aggregate (sum, avg, etc) the table to higher level. But the time needed to do the aggregation is very long (without aggregation is around 10 mins, with aggregation is around 1 hour). Is there a way/trick to speed it up?

2 Replies
Not applicable

Re: Improve Aggregation Performance

Maybe push aggregation to the database? You'd limit memory requirements on QV side and network traffic between DB and QV

Not applicable

Re: Improve Aggregation Performance

Hi Lukasz,

Unfortunately, we can't do the aggregation in the DB/source.

Community Browser