Talend Create Select Performance tuning

Question

I just realised that when I run a create select statement on my Oracle 11g database the execution is about three times faster than using Talend to select the data then creating and writing the data into the new table.

So I am wondering if there is a way to just connect to the database and run the create select query on the database in talend.

Answer 1

I finally found a way to run the create-select query directly on the DB with the expected performance using the tDBRow for MySQL (formerly tMySQLRow) component as shown in the screenshot below.

Here is a screenshot of the result.