topic Re: Saving a resident table in QlikView

Saving a resident table

Anonymous — Wed, 29 Apr 2015 18:02:54 GMT

Hi,

I have a script that create a resident table of 100k rows, is not a very large table, but the scripts takes a little to create it, because there are some calculattions, merges and agregations...

I don't want to reexecute the script every time I start a Qlick session to work with tha table. I suppose there is a way to save/store this resident table and reload it to use it in next sessions.

Which is the best way to store a resident table?

Thanks in advance

Re: Saving a resident table

Anonymous — Wed, 29 Apr 2015 18:03:56 GMT

Yes - look at the QVD files

Re: Saving a resident table

maxgro — Wed, 29 Apr 2015 18:06:12 GMT

search store in the help

Examples:

Store mytable into xyz.qvd (qvd);

Store * from mytable into xyz.qvd;

Store Name, RegNo from mytable into xyz.qvd;

Store Name as a, RegNo as b from mytable into xyz.qvd;

store mytable into myfile.txt (txt);

store * from mytable into myfile.txt (txt);

(The two first examples have identical function.)

Re: Saving a resident table

jaimeaguilar — Wed, 29 Apr 2015 18:13:49 GMT

Hi,

You can store this table to QVD and reload it into your model any time you need it. In general is faster to reload a table from QVD than reloading it from a resident table. The advantage of using a resident load is that you reuse a table that is already in-memory, so you're just creating an additional pointer to an already existing table.

Also you may want to read about qvd optimized load to ensure the fastest possible load times,

regards