topic Parallel Load in QlikView https://community.qlik.com/t5/QlikView/Parallel-Load/m-p/535800#M200223 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif';">Hi Qlikers:</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">I need to reload a humongous table 20 million record and 102 fields.</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">I positively know that there is a parameter called <STRONG>Enable Parallel Load</STRONG>, that shares the task among processors.</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">Does anybody know how to set that for SAP? Where is set?</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">The next is an example for Oracle. 4 is the number of processors you want to use. This one reduces time to half.</SPAN></P><P><SPAN lang="ES" style="color: black;">Select&nbsp;&nbsp; /*+ PARALLEL(tabla1 , 4) PARALLEL(tabla2 , 4)&nbsp; */&nbsp; </SPAN></P><P><SPAN lang="ES" style="color: black;">&nbsp;&nbsp;&nbsp; Sum(tabla1.importe) </SPAN></P><P><SPAN lang="ES" style="color: black;">from tabla1, tabla2, tabla3</SPAN></P><P><SPAN lang="ES" style="color: black;">where tabla1.codigo = tabla2.codigo</SPAN></P><P><SPAN lang="ES" style="color: black;">and tabla2.codigo = tabla3.codigo</SPAN></P><P><SPAN lang="ES" style="color: black;"></SPAN> </P><P><SPAN lang="ES" style="color: black;">SQL does it automatically.</SPAN></P><P><SPAN lang="ES" style="color: black;"> </SPAN></P><P><SPAN lang="ES" style="color: black;">Thank you.</SPAN></P></BODY></HTML> Wed, 09 Oct 2013 16:56:15 GMT christian77 2013-10-09T16:56:15Z Parallel Load https://community.qlik.com/t5/QlikView/Parallel-Load/m-p/535800#M200223 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-family: 'Arial','sans-serif';">Hi Qlikers:</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">I need to reload a humongous table 20 million record and 102 fields.</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">I positively know that there is a parameter called <STRONG>Enable Parallel Load</STRONG>, that shares the task among processors.</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">Does anybody know how to set that for SAP? Where is set?</SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Arial','sans-serif';">The next is an example for Oracle. 4 is the number of processors you want to use. This one reduces time to half.</SPAN></P><P><SPAN lang="ES" style="color: black;">Select&nbsp;&nbsp; /*+ PARALLEL(tabla1 , 4) PARALLEL(tabla2 , 4)&nbsp; */&nbsp; </SPAN></P><P><SPAN lang="ES" style="color: black;">&nbsp;&nbsp;&nbsp; Sum(tabla1.importe) </SPAN></P><P><SPAN lang="ES" style="color: black;">from tabla1, tabla2, tabla3</SPAN></P><P><SPAN lang="ES" style="color: black;">where tabla1.codigo = tabla2.codigo</SPAN></P><P><SPAN lang="ES" style="color: black;">and tabla2.codigo = tabla3.codigo</SPAN></P><P><SPAN lang="ES" style="color: black;"></SPAN> </P><P><SPAN lang="ES" style="color: black;">SQL does it automatically.</SPAN></P><P><SPAN lang="ES" style="color: black;"> </SPAN></P><P><SPAN lang="ES" style="color: black;">Thank you.</SPAN></P></BODY></HTML> Wed, 09 Oct 2013 16:56:15 GMT https://community.qlik.com/t5/QlikView/Parallel-Load/m-p/535800#M200223 christian77 2013-10-09T16:56:15Z