Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Store model as QVDs which are already loaded into memory

Hi Guys,

Is it possible that QVDs which are already loaded into the memory can be stored without reloading the whole script?

For example I have a fact table which needs to be stored as .QVD into a folder but the model is already in memory. I don't what to reload the whole model because it has a loading time of 7 hours...

Kind regards

Robert

Tags (1)
5 Replies
Highlighted
Master
Master

Re: Store model as QVDs which are already loaded into memory

Hi Robert,

This is not possible, you should also look for incremental load for qvd, I'll think this will decrease Your loading time.

Highlighted
Specialist III
Specialist III

Re: Store model as QVDs which are already loaded into memory

Highlighted
Partner
Partner

Re: Store model as QVDs which are already loaded into memory

You can Binary load the data model from another app, i.e. your QVD export/save app. Binary loads are significantly faster and after your binary load you may continue to store tables just as you would in a normal load script:

binary test.qvw; //Must be first script statement.

store Transactions into Transactions.qvd (qvd);

Highlighted
Master
Master

Re: Store model as QVDs which are already loaded into memory

Nice work around Jonas!

Highlighted
MVP
MVP

Re: Store model as QVDs which are already loaded into memory

Or just copy this at the top of your script:

store Transactions into Transactions.qvd (qvd);

exit script;


and perform a partial reload