Data insert or update very slow !!

[Anonymous]

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.

[Anonymous]

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/7...

[Anonymous]

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.