Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

6 Replies
stabben23
Partner - Master
Partner - Master

Hi Robert,

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

rahulpawarb
Specialist III
Specialist III

kjhertz
Partner - Creator
Partner - Creator

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);

stabben23
Partner - Master
Partner - Master

Nice work around Jonas!

swuehl
MVP
MVP

Or just copy this at the top of your script:

store Transactions into Transactions.qvd (qvd);

exit script;


and perform a partial reload

DeAsz
Partner - Contributor
Partner - Contributor

Exactly this is the way to do it, still in April-23'