topic Performance Problems with Count/Sum function in QlikView https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371910#M1306673 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a qvw Script in a Server environment with max. 5 tables.</P><P>In one table i have a field with IDs and i created a data set count field (1 as FieldID) to sum or count it at the UI, but the performance is very slow.</P><P>The Table with the FieldID have ca. 60 Millions data sets.The server have a little more than 24 GB RAM. </P><P>Habe anyone have an idea why the performance is so slow? </P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT 2026-01-26T18:19:17Z Performance Problems with Count/Sum function https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371910#M1306673 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>i have a qvw Script in a Server environment with max. 5 tables.</P><P>In one table i have a field with IDs and i created a data set count field (1 as FieldID) to sum or count it at the UI, but the performance is very slow.</P><P>The Table with the FieldID have ca. 60 Millions data sets.The server have a little more than 24 GB RAM. </P><P>Habe anyone have an idea why the performance is so slow? </P></BODY></HTML> Mon, 26 Jan 2026 18:19:17 GMT https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371910#M1306673 2026-01-26T18:19:17Z Performance Problems with Count/Sum function https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371911#M1306675 <HTML><HEAD></HEAD><BODY><P>Can you post a reduced version of the app we can look at?</P></BODY></HTML> Fri, 27 Apr 2012 09:46:46 GMT https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371911#M1306675 Jason_Michaelides 2012-04-27T09:46:46Z Performance Problems with Count/Sum function https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371912#M1306678 <HTML><HEAD></HEAD><BODY><P>did a short test with 30.000.000 records (autogenerated) - on my quadcore notebook with 8GB RAM absolutely no problem to do sum() over all records. Even count( distinct xxxxx) over 30.000.000 values was no problem...</P><P>No performance issues.</P><P>regards,,</P><P>Edgar </P></BODY></HTML> Fri, 27 Apr 2012 10:16:13 GMT https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371912#M1306678 ekech_infomotio 2012-04-27T10:16:13Z Re: Performance Problems with Count/Sum function https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371913#M1306682 <HTML><HEAD></HEAD><BODY><P>Did you solve your problem? I'm having the same issue. </P><P>Sum() is terrible slow.</P><P></P><P>Any suggestions?</P><P></P><P>Best Regards</P><P>Ramon</P></BODY></HTML> Sun, 05 Aug 2012 19:00:09 GMT https://community.qlik.com/t5/QlikView/Performance-Problems-with-Count-Sum-function/m-p/371913#M1306682 2012-08-05T19:00:09Z