topic Re: What is a better practise? Storing a table in QVD format and loading it again in that format or doing a resident load? This for when you further need to transform a table in QlikView

What is a better practise? Storing a table in QVD format and loading it again in that format or doing a resident load? This for when you further need to transform a table

jblomqvist — Mon, 12 Sep 2016 18:18:48 GMT

Hi all,

What is a better practise? Storing a table in QVD format and loading it again or doing a resident load? This for when you further need to transform a table.

E.g. I have an Orders table, I store it in a QVD file format and then further down the script I load it again to continue further transforming it.

Is this better than doing a Resident load?

And why is it better?

Re: What is a better practise? Storing a table in QVD format and loading it again in that format or doing a resident load? This for when you further need to transform a table

swuehl — Mon, 12 Sep 2016 18:26:39 GMT

I would suggest to test both approached with your data and transformations.

There are some discussions and blog posts that may imply that QVD Store / LOAD is faster than a RESIDENT, but YMMV.

Qvd Vs Resident load | Qlik Community

Re: What is a better practise? Storing a table in QVD format and loading it again in that format or doing a resident load? This for when you further need to transform a table

janarthanan_rb — Mon, 12 Sep 2016 19:34:51 GMT

For loading the same table in same qvw the resident load is the better choice.

Re: What is a better practise? Storing a table in QVD format and loading it again in that format or doing a resident load? This for when you further need to transform a table

Anonymous — Mon, 12 Sep 2016 20:26:16 GMT

Stefan Wühl is right.

Standard answer from a consultant: It depends. So you have to try what is faster depending on your transformations!