topic Improving for loop speed in QlikView

Improving for loop speed

andreminnaar — Sat, 16 Nov 2024 01:56:17 GMT

Hi all

I have a problem with my speed in the following example. On the smaller data set it is perfect but I need to run this on a 4,7m record data set. Is there something that I can change or something different that I can try to reduce the building time but get the same result?

Re: Improving for loop speed

rubenmarin — Fri, 15 Nov 2019 08:25:43 GMT

Hi, time ago I did something similar, the bucle goes too slow and using peek() with 12 fields, rangemax() and rangemin() improve the loading times. No sure if this can be your case, with this few rows is hard to check differences.

Re: Improving for loop speed

andreminnaar — Fri, 15 Nov 2019 10:37:49 GMT

Thank you @rubenmarin.

This took the building time from days down to 4 min.