idea From now on, please track this idea from the Ideation por... in Suggest an Idea

Re: Qlik Script: Multi-Threaded GROUP BY, especially Sum()

humansoft — Thu, 17 Mar 2022 14:50:28 GMT

Please vote and promote the idea! 😀

Re: Qlik Script: Multi-Threaded GROUP BY, especially Sum()

Ben_at_Kohls — Thu, 17 Mar 2022 15:52:11 GMT

This feature would great improve the scalability of SaaS for an organization like mine that has large data volumes and we probably aren't even close to being the biggest. Strongly support adding this capability.

Re: Qlik Script: Multi-Threaded GROUP BY, especially Sum()

AlexOmetis — Thu, 17 Mar 2022 15:56:28 GMT

It definitely is unintuitive that Qlik is so quick at aggregation in the front end but so slow at it in the back end. I'd definitely like for more multi-threading support for sure.

I have found some ways to work around this a little though - e.g. don't use group by with a where clause - you're better off loading the data with a where clause and then doing group by as a resident load. Some of those findings are written up in a blog I wrote a few years ago... A Journey In Load Optimisation - Ometis

Re: Qlik Script: Multi-Threaded GROUP BY, especially Sum()

simonaubert — Mon, 02 May 2022 09:08:37 GMT

Really ? It remains single-threaded for script? O_o Do you have some documentation where we can find which operation is still single-threaded?

Best regards,

Simon

From now on, please track this idea from the Ideation por...

Meghann_MacDonald — Mon, 18 Sep 2023 17:46:49 GMT

From now on, please track this idea from the Ideation portal.

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Re: Qlik Script: Multi-Threaded GROUP BY, especially Sum() - Status changed to: Closed - Archived

Ideation — Mon, 18 Sep 2023 17:46:51 GMT