Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Robert,
This is not possible, you should also look for incremental load for qvd, I'll think this will decrease Your loading time.
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);
Nice work around Jonas!
Or just copy this at the top of your script:
store Transactions into Transactions.qvd (qvd);
exit script;
and perform a partial reload
Exactly this is the way to do it, still in April-23'