loads

maniram23 — Mon, 04 May 2015 17:47:40 GMT

Hi experts,

which one is the better performance as compare to preceding load and resident load?

Re: loads

Mon, 04 May 2015 19:21:03 GMT

Hi,

Have a look here

Preceding Load

And in the comments:

hic 6 mars 2013 02:32 (en réponse à Hariharasudan P )

If you compare a single preceding Load with a single resident Load where the two Loads have identical content, then I would say that the preceding Load always is faster. In the preceding Load, the records are evaluated "on the fly" and this makes it fast.

I made a small test where I had a Load with a few string operations. When I put them in a preceding Load, the script execution time increased by 15-20%. When I put them in a resident Load, script execution time increased by 90-100%. So, I would say: If you can put your calculation in a preceding Load, you should. But sometimes you have to use a resident Load, e.g. after a Crosstable or when you want to make some transformations after a Join.

However, a preceding Load has a small overhead, so if you have multiple preceding Loads, it will be slower. But if a preceding Load helps the manageability and clarity of the script, then I am usually willing to take a small penalty.

HIC

However i've note better performance with resident load when aggregation or lookups are needed.

topic loads in QlikView

loads

Re: loads