topic Re: Improve Aggregation Performance in QlikView https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588997#M680427 <HTML><HEAD></HEAD><BODY><P>Maybe push aggregation to the database? You'd limit memory requirements on QV side and network traffic between DB and QV </P></BODY></HTML> Wed, 02 Apr 2014 07:53:45 GMT 2014-04-02T07:53:45Z Improve Aggregation Performance https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588996#M680426 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>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?</P></BODY></HTML> Wed, 02 Apr 2014 07:49:44 GMT https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588996#M680426 2014-04-02T07:49:44Z Re: Improve Aggregation Performance https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588997#M680427 <HTML><HEAD></HEAD><BODY><P>Maybe push aggregation to the database? You'd limit memory requirements on QV side and network traffic between DB and QV </P></BODY></HTML> Wed, 02 Apr 2014 07:53:45 GMT https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588997#M680427 2014-04-02T07:53:45Z Re: Improve Aggregation Performance https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588998#M680428 <HTML><HEAD></HEAD><BODY><P>Hi Lukasz,</P><P></P><P>Unfortunately, we can't do the aggregation in the DB/source.</P></BODY></HTML> Thu, 03 Apr 2014 03:28:26 GMT https://community.qlik.com/t5/QlikView/Improve-Aggregation-Performance/m-p/588998#M680428 2014-04-03T03:28:26Z