topic Re: Data insert or update very slow !! in Talend Studio

Data insert or update very slow !!

Anonymous — Thu, 05 May 2016 07:40:36 GMT

Hi,
I'm using Talend 6.1.1 Talend Data Integration Tool and we store data in MYSQL (AZURE CLOUD).
My issue is, if i use insert or update for incremental load -- then it loads at the rate of 9 rows/sec..
if i use only insert option -- then it was 400 rows/sec..
We need insert or update option with high speed. What can we do for higher throwput.

Re: Data insert or update very slow !!

Anonymous — Thu, 05 May 2016 08:28:17 GMT

Hello
Check this link you ll get a clear idea https://community.talend.com/t5/Design-and-Development/How-does-tPostgresqlOutput-Update-work/td-p/70748

Re: Data insert or update very slow !!

Anonymous — Thu, 05 May 2016 08:39:21 GMT

Yes, i know. Update = select condition + insert / update.
My problem is with performance. It only allows 9 rows/sec. Which is very bad. How to overcome this situation.