Autocommit in tMysqlConnection

One Star

Autocommit in tMysqlConnection

Hi,
I have designed one job where data is inserted in parent and child tables and I have used tMysqlcommit component to commit the records at a time. So while processing, it is taking huge time to commit as I have crores records and in between if I get any exception whole time getting wasted. So can I use Autocommit option in tMysqlConnection component to commit every single transaction or shall I create connection in tMysqlOutput separately for each table instead of using existing connection to process the data fastly? Can you please help me to resolve it?
One more thing is if we create connection in tMysqlOutput for each table instead of using existing connection, Do id's whatever inserting in parent and child maintain correctly?
Moderator

Re: Autocommit in tMysqlConnection

Hi sabitha566,
Could you please post your current job design screenshots into forum which will be helpful for us to understand your problem?
Best regards
Sabrina 
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

Definitive Guide to Data Quality

Create systems and workflow to manage clean data ingestion and data transformation.

Download