Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
AFAIK they both take the same amount of time. But would be curious to know what others think
UPDATE: I might be wrong here
I don´t think there´s so much diffrence.
I would try on each situation and choose the fastest (each case can be diffrent)
There has been similar questions in the past, check them out:
https://community.qlikview.com/thread/85925
Read HIC's response here -> https://community.qlik.com/blogs/qlikviewdesignblog/2013/03/04/preceding-load?_ga=1.244883333.149577...
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
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
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.
You mean when we are loading multiple files using a wildcard in the filename?
Thank you all for your insightful replies