Discussion Board for collaboration on QlikView Scripting.
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?
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.
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.