topic Re: Avoid reloading a qvd in QlikView https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427449#M159264 <HTML><HEAD></HEAD><BODY><P>You should look into optimizing the QVD load so it takes only a few seconds to load.</P></BODY></HTML> Wed, 16 Jan 2013 14:47:09 GMT danielrozental 2013-01-16T14:47:09Z Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427448#M159263 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>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</P><P></P><P>Please advise</P></BODY></HTML> Wed, 16 Jan 2013 14:35:35 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427448#M159263 2013-01-16T14:35:35Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427449#M159264 <HTML><HEAD></HEAD><BODY><P>You should look into optimizing the QVD load so it takes only a few seconds to load.</P></BODY></HTML> Wed, 16 Jan 2013 14:47:09 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427449#M159264 danielrozental 2013-01-16T14:47:09Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427450#M159265 <HTML><HEAD></HEAD><BODY><P>Hi Daniel, </P><P></P><P>Can you advise how would I optimize my qvd.</P></BODY></HTML> Wed, 16 Jan 2013 18:06:52 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427450#M159265 2013-01-16T18:06:52Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427451#M159266 <HTML><HEAD></HEAD><BODY><P>Sure, post your load script and I will</P></BODY></HTML> Wed, 16 Jan 2013 18:07:45 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427451#M159266 danielrozental 2013-01-16T18:07:45Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427452#M159267 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>To optimize your QVD load time, you can split it in multiple QVDs. One by YearMonth for example.</P><P>And if you can have some update on the last 2 months, you just have to load the 3 last QVDs.</P><P></P><P>Hope that helps you.</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 18:11:02 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427452#M159267 martin59 2013-01-16T18:11:02Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427453#M159268 <HTML><HEAD></HEAD><BODY><P>I have only 3 days worth of data.. but it is a huge table with around 100M</P></BODY></HTML> Wed, 16 Jan 2013 20:20:18 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427453#M159268 2013-01-16T20:20:18Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427454#M159269 <HTML><HEAD></HEAD><BODY><P>Please post your script.</P></BODY></HTML> Wed, 16 Jan 2013 20:20:54 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427454#M159269 danielrozental 2013-01-16T20:20:54Z Re: Avoid reloading a qvd https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427455#M159270 <HTML><HEAD></HEAD><BODY><P>Could you post your script please ?</P><P></P><P>Martin Favier</P></BODY></HTML> Wed, 16 Jan 2013 22:18:18 GMT https://community.qlik.com/t5/QlikView/Avoid-reloading-a-qvd/m-p/427455#M159270 martin59 2013-01-16T22:18:18Z