Hello Sirs ,
In the below scenarion What shall be the possible ways to reduce qvd creation time from another qvd (STEP 2) ?
Sorry , if i am asking a very simple question .
Is there any way to track and note which piece of script is taking more time , other than manual eye rolling on window .
Thank You Jfkinspari .
Being new to qlik , i often end up asking comman things like this .
Now i need to look for , how to use TRACE statement .
let say there is a qvd load and i am applying two lookup and one subfield statement , would TRACE help me in finding how much of time each lookup and subfield took ?
,lookup(............) as F4
lookup(.............) as F7,
subfield(..........) as F8
from xyz.qvd ;
Most effectual would be to use incremental load-approaches on each of your transformating-steps. Further if your extractings contain multiple load-statements it might be useful to separate them into multiple working-steps, too. In the second half of the following posting you will find various examples to incremental approaches and exists() which is needed to keep qvd-loadings optimized: