In a QlikView script we run an incremental load which easily sums up to 13 million rows per month. Therefore optimizing the script is key. I have been searching the community but most discussions found by me focussed on either on the front-end or a single case.
(1) Does anyone have an overview or suggestions on which functions are single-threaded versus multi-threaded in the QlikView script?
(2) Is there difference in the peformance of various single-threaded functions?
Would be happy with suggestions,
P.s.: one of the steps I am trying to optimize involves an Order by linked to a Peek function.