What is faster? Resident Loads or Loads on Preceding Loads?

[mwallman]

Hi,

Can anybody please tell me what is faster? Resident Loads or Loads on Preceding Loads?

Or generally they are about the same?

E.g. I want to do some further calculations on some fields, is it better to use Resident Load or Preceding Loads?

[sunny_talwar]

AFAIK they both take the same amount of time. But would be curious to know what others think

UPDATE: I might be wrong here

[Clever_Anjos]

I don´t think there´s so much diffrence.

I would try on each situation and choose the fastest (each case can be diffrent)

[sunny_talwar]

There has been similar questions in the past, check them out:

https://community.qlikview.com/thread/85925

Preceding Load and Resident Load‌

Preceding Load

[sunny_talwar]

Read HIC's response here -> https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load?_ga=1.244883333.149577...

[avinashelite]

As per my experience  Preceding Loads has an edge over the Resident Loads because Preceding are calculated on fly and Resident loads are done over the previously loaded table (which might be a normal load or Preceding)..so its always better to go with the Preceding loads , it will not occupy additional memory .

I might be wrong too because it all go with the data size and your requirement

[Peter_Cammaert]

True. A preceding LOAD is almost always faster than a resident LOAD.

EXCEPT that sometimes a preceding load may crash your script (without any sensible explanation). For example, I would advise to never ever try a preceding LOAD on a LOAD FROM with file name wildcards.

Peter

[ramasaisaksoft]

Hi Michael,

For the first time may be both are same time

but from 2nd  time Resident load only Fast.Why because preceding load always depends/fetch data from another outside file,but resident load is not depend on the other file.

it is also depending on calculations you specified.

[sunny_talwar]

You mean when we are loading multiple files using a wildcard in the filename?

[mwallman]

Thank you all for your insightful replies