Sunday, June 17, 2012

Beware - Talend's tMysqlOutputBulkExec Clear Table is a scam

tMysqlOutputBulkExec is a heavily used Talend component. Just recently I found out that the "Clear Table" option in the Basic Settings of the component is a scam. How? Well, you'd imagine it'd truncate the table because the option says "Clear Table". But NO!

It actually issues the "DELTE FROM" command!!!!

Totally horrible. It takes forever to delete rather than just truncate the table. Beware of this little nitty gritty detail. It does not truncate the table which is the fastest way.

The workaround is to create a mysqlrow component to execute the truncate table statement in your flow.

UPDATE: This is a problem on 4.2.3 version only. Apparently it got fixed in the 5.x version

No comments:

Post a Comment