Data insert or update very slow !!

One Star

Data insert or update very slow !!

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.
One Star

Re: Data insert or update very slow !!

Hello
Check this link you ll get a clear idea https://www.talendforge.org/forum/viewtopic.php?id=2305
One Star

Re: Data insert or update very slow !!

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.