https://community.qlik.com/t5/Talend-Studio/Optimize-the-execution-time-of-the-job-for-loading-data/m-p/2315574#M142710 <P>Hello </P><P>Refer to this <A href="https://www.girikon.com/blog/performance-tips-reusability-in-talend-data-integration/" alt="https://www.girikon.com/blog/performance-tips-reusability-in-talend-data-integration/" target="_blank">page </A>about Performance Optimization Tips, like allocating more memory to job execution, using database bulk components.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>&nbsp;</P> Tue, 07 Sep 2021 06:38:07 GMT Anonymous 2021-09-07T06:38:07Z https://community.qlik.com/t5/Talend-Studio/Optimize-the-execution-time-of-the-job-for-loading-data/m-p/2315573#M142709 <P>Hey everyone , </P><P>My job is loading data from an mysql table to postgresql table , so it copy 27 Go ( 46 millions of rows ) of data from one table to another .</P><P>The job run 8 hours to do that ( Exportation of the job on linux script and execution on the server ) which is not satisfying for me .Any solution to minimize the 8 hours ? </P><P>Ps : I use talend open studio for data integration </P><P>Thank you </P> Fri, 15 Nov 2024 23:46:57 GMT https://community.qlik.com/t5/Talend-Studio/Optimize-the-execution-time-of-the-job-for-loading-data/m-p/2315573#M142709 elsaaa 2024-11-15T23:46:57Z https://community.qlik.com/t5/Talend-Studio/Optimize-the-execution-time-of-the-job-for-loading-data/m-p/2315574#M142710 <P>Hello </P><P>Refer to this <A href="https://www.girikon.com/blog/performance-tips-reusability-in-talend-data-integration/" alt="https://www.girikon.com/blog/performance-tips-reusability-in-talend-data-integration/" target="_blank">page </A>about Performance Optimization Tips, like allocating more memory to job execution, using database bulk components.</P><P>&nbsp;</P><P>Regards</P><P>Shong</P><P>&nbsp;</P> Tue, 07 Sep 2021 06:38:07 GMT https://community.qlik.com/t5/Talend-Studio/Optimize-the-execution-time-of-the-job-for-loading-data/m-p/2315574#M142710 Anonymous 2021-09-07T06:38:07Z