Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
mwallman
Contributor

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

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

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)

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

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

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

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

ramasaisaksoft
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.

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?

mwallman
Contributor

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

Thank you all for your insightful replies

Community Browser