topic QVD creation in QlikView https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304526#M1202103 <HTML><HEAD></HEAD><BODY><P>All in one load script.</P></BODY></HTML> Tue, 08 Feb 2011 16:58:35 GMT john_duffy 2011-02-08T16:58:35Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304522#M1202096 <HTML><HEAD></HEAD><BODY><P>....</P></BODY></HTML> Tue, 08 Feb 2011 16:29:24 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304522#M1202096 2011-02-08T16:29:24Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304523#M1202098 <HTML><HEAD></HEAD><BODY><P>Doesn't it work to do for each qvd:</P><P>1) load data<BR />2) export to a qvd file<BR />3) drop the table</P><P>I think it could prevent QlikView to do the linking between tables and also reduce the memory footprint of your script.</P></BODY></HTML> Tue, 08 Feb 2011 16:50:42 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304523#M1202098 2011-02-08T16:50:42Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304524#M1202100 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P>You can delete the QlikView resident table after each QVD is created. Our QVD load process is as follows:</P><UL><LI>Load the data from the database to a resident QV table.</LI><LI>Store the resident table into a QVD.</LI><LI>Drop the resident table.</LI></UL><P>There are no tables to link at the end of the application load.</P><P>Let me know if this helps,</P><P>John.</P></BODY></HTML> Tue, 08 Feb 2011 16:51:55 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304524#M1202100 john_duffy 2011-02-08T16:51:55Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304525#M1202101 <HTML><HEAD></HEAD><BODY><P>Do you mean to do it in multiple scripts or all in one script?</P></BODY></HTML> Tue, 08 Feb 2011 16:52:31 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304525#M1202101 2011-02-08T16:52:31Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304526#M1202103 <HTML><HEAD></HEAD><BODY><P>All in one load script.</P></BODY></HTML> Tue, 08 Feb 2011 16:58:35 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304526#M1202103 john_duffy 2011-02-08T16:58:35Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304527#M1202104 <HTML><HEAD></HEAD><BODY><P>doing it in one single script should be enough</P></BODY></HTML> Tue, 08 Feb 2011 16:59:42 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304527#M1202104 2011-02-08T16:59:42Z QVD creation https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304528#M1202105 <HTML><HEAD></HEAD><BODY><P>Thanks both, i will try that and let you know. Thanks</P></BODY></HTML> Tue, 08 Feb 2011 17:02:29 GMT https://community.qlik.com/t5/QlikView/QVD-creation/m-p/304528#M1202105 2011-02-08T17:02:29Z