topic Optimize the code for incremental process in QlikView https://community.qlik.com/t5/QlikView/Optimize-the-code-for-incremental-process/m-p/282549#M105041 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Hello,</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">We are facing big problem in my project deployment. I've developed two qvw files one is for initial load and another for incremental load. I'm facing problem for incremental load. According to my code the incremental process is taking 7-8 hours. So we optimize the code which we devleoped and now it is taking only 30mins but it is not giving updated data. I think the<STRONG> concatenate process</STRONG> is giving problem.</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Here i'm attaching my qvw files along initial load file.</SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt;">1_IncrementalLoad.qvw -&gt; 7-8 hours</SPAN></P><P><SPAN style="font-size: 16px;">2_IncrementalLoad.qvw -&gt;30mins</SPAN></P><P></P><P>I've huge amount of data in text files.</P><P></P><P><SPAN style="font-size: 16px;">Can anyone please help me how to overcome all this problems. <BR /></SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P></BODY></HTML> Wed, 15 Feb 2012 08:59:37 GMT 2012-02-15T08:59:37Z Optimize the code for incremental process https://community.qlik.com/t5/QlikView/Optimize-the-code-for-incremental-process/m-p/282549#M105041 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Hello,</SPAN></P><P></P><P><SPAN style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">We are facing big problem in my project deployment. I've developed two qvw files one is for initial load and another for incremental load. I'm facing problem for incremental load. According to my code the incremental process is taking 7-8 hours. So we optimize the code which we devleoped and now it is taking only 30mins but it is not giving updated data. I think the<STRONG> concatenate process</STRONG> is giving problem.</SPAN></P><P></P><P><SPAN style="font-size: 12pt;">Here i'm attaching my qvw files along initial load file.</SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P><P><SPAN style="font-size: 12pt;">1_IncrementalLoad.qvw -&gt; 7-8 hours</SPAN></P><P><SPAN style="font-size: 16px;">2_IncrementalLoad.qvw -&gt;30mins</SPAN></P><P></P><P>I've huge amount of data in text files.</P><P></P><P><SPAN style="font-size: 16px;">Can anyone please help me how to overcome all this problems. <BR /></SPAN></P><P><SPAN style="font-size: 12pt;"><BR /></SPAN></P></BODY></HTML> Wed, 15 Feb 2012 08:59:37 GMT https://community.qlik.com/t5/QlikView/Optimize-the-code-for-incremental-process/m-p/282549#M105041 2012-02-15T08:59:37Z