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.
2 REPLIES
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.