Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor II

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

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?

16 Replies
Highlighted

Re: What is faster? Resident Loads or Loads on 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

Highlighted
Employee
Employee

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

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

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

Highlighted

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

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

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

Preceding Load and Resident Load

Preceding Load

Highlighted

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

Highlighted

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

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

Highlighted

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

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

Highlighted
Valued Contributor III

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

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.

Highlighted

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

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

Highlighted
Contributor II

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

Thank you all for your insightful replies