Avoid reloading a qvd

[#1]

Hi,

I am using incremental loads for one of my qvw but I also load a qvd while performing the incremental loads which has more than 100M records. Is there a way, I can avoid loading the qvd evrytime I run the incrementals and somehow concatenate my new table to the exisitng qvd. Curretnly it takes a long time to reload the qvd

Please advise

[danielrozental]

You should look into optimizing the QVD load so it takes only a few seconds to load.

[#3]

Hi Daniel,

Can you advise how would I optimize my qvd.

[danielrozental]

Sure, post your load script and I will

[martin59]

Hi,

To optimize your QVD load time, you can split it in multiple QVDs. One by YearMonth for example.

And if you can have some update on the last 2 months, you just have to load the 3 last QVDs.

Hope that helps you.

Martin Favier

[#6]

I have only 3 days worth of data.. but it is a huge table with around 100M

[danielrozental]

Please post your script.

[martin59]

Could you post your script please ?

Martin Favier