Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
andreminnaar
Contributor II
Contributor II

Improving for loop speed

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?

 
 
Labels (4)
1 Solution

Accepted Solutions
rubenmarin

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.

View solution in original post

2 Replies
rubenmarin

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.

andreminnaar
Contributor II
Contributor II
Author

Thank you @rubenmarin.

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