topic Re: How to make job execution faster? in Talend Studio https://community.qlik.com/t5/Talend-Studio/How-to-make-job-execution-faster/m-p/2345255#M112811 <P>Hi </P><P>The performance depends on how many tables you need to migrate and the data volume of each table. This is a simple Job, I don't think we have much to optimize, one point I suggest is to commit the change for each iteration after tOracleOutput.</P><P>...tOracleOutput--oncomponentok--tDBCommit</P><P>|onsubjobok</P><P>tOracleClose1...</P><P>&nbsp;</P><P>What is the error if you enable parallel execution on iteration (after tjavaFlex_3)?</P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>​</P> Fri, 03 Feb 2023 08:11:10 GMT Anonymous 2023-02-03T08:11:10Z How to make job execution faster? https://community.qlik.com/t5/Talend-Studio/How-to-make-job-execution-faster/m-p/2345254#M112810 <P>Hello,</P><P></P><P></P><P>I am running a migration job with the attached design, and it is taking a whole day to complete.</P><P>Is there any way to shorten the execution time?</P><P>I have tried to execute the subjob which has β€œrow1” in parallel following this guide (<A href="https://help.talend.com/r/en-US/8.0/studio-user-guide/executing-multiple-subjobs-in-parallel" target="_blank">https://help.talend.com/r/en-US/8.0/studio-user-guide/executing-multiple-subjobs-in-parallel</A>), but I have been failing.</P><P></P><P></P><P>Thanks in advance,</P> Fri, 15 Nov 2024 22:08:46 GMT https://community.qlik.com/t5/Talend-Studio/How-to-make-job-execution-faster/m-p/2345254#M112810 StreetTalender 2024-11-15T22:08:46Z Re: How to make job execution faster? https://community.qlik.com/t5/Talend-Studio/How-to-make-job-execution-faster/m-p/2345255#M112811 <P>Hi </P><P>The performance depends on how many tables you need to migrate and the data volume of each table. This is a simple Job, I don't think we have much to optimize, one point I suggest is to commit the change for each iteration after tOracleOutput.</P><P>...tOracleOutput--oncomponentok--tDBCommit</P><P>|onsubjobok</P><P>tOracleClose1...</P><P>&nbsp;</P><P>What is the error if you enable parallel execution on iteration (after tjavaFlex_3)?</P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>​</P> Fri, 03 Feb 2023 08:11:10 GMT https://community.qlik.com/t5/Talend-Studio/How-to-make-job-execution-faster/m-p/2345255#M112811 Anonymous 2023-02-03T08:11:10Z