Recursive loop is a very powerful and wise however its speed slows down significantly after 10 iterations. Hope it improves with the time.
do you have an example where is performance gets bad over time?
Maybe then we could give you suggestions how to keep it going faster
I think it highly depends on how the data is forwarded to the loop
The data quantity is not too big. However nodes like JOIN and Rule based row filter gives all the problem.
Join actually even stop working somewhere around iteration 30+. It gives some error don’t remember exactly but it says Java… So i have created another workflow that don’t remove rows but rather do some data modification via nodes like lag column, Rule Engine, math formula etc… Also i have chosen an option to pick up last iteration only. Actually excel can do it in meter of seconds… with something like countif formula
loops do know to become slower as iterations go further. As @AnotherFraudUser it would be best to share example workflow so someone can check it or suggest optimization steps.
One suggestion is to use new and improved joiner node available with KNIME 4.2.0. - Joiner (Labs)
Thank you. 4.2 is not yet integrated for our organization but definitely if will try it whenever its possible. Sorry but i’ve delted to wf so cannot share it. The newer ones looks like this:
I see. Well then I can suggest this blog post about optimizing KNIME workflows:
Hope you’ll find something applicable for your workflow
check this topic: Recursive loop performance issue
Probably same issue you had. RowIDs growing longer and longer with each iteration due to Joiner node.
Hello @ipazin . Thank you very much for your help. i’ve solved it in my own way however what you wrote make sense! Hopefully i will remember it next time when i need to use recursive loop.
Thank you again!!!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.