multi thread execution job

[Anonymous]

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?

[Anonymous · Accepted solution]

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

[Anonymous]

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