Improve Aggregation Performance

[#1]

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]

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

[#3]

Hi Lukasz,

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