topic multi thread execution job in Talend Studio

multi thread execution job

Anonymous — Thu, 15 Mar 2018 06:22:00 GMT

i have talend open studio,

and i created a job to copy from tOracleinput to tMySQLoutput.

i tried to run after checking windows -> preference -> talend -> multi thread execution,

but elpased time was same.

how run the job fast. is there anyway?

Re: multi thread execution job

Anonymous — Thu, 15 Mar 2018 12:30:03 GMT

Hi,

Talend Open Studio does not support multi thread execution.

On one to improve your job performance could be to use bulk loading to MySQL instead of using a tMySQLOutput component .

Try using a tMysqlOutputBulkExec will speed up the loading to the MySQL DB.

BR Bp

Re: multi thread execution job

Anonymous — Tue, 20 Mar 2018 09:14:22 GMT

Hello,

If the 'Multi-thread exectuion' box is checked, the different subjobs in the main job will execute parallel rather than one by one, which is not used for bulk loading

Best regards

Sabrina