topic Re: [resolved] Slow uploading speed to Vertica in Talend Studio

[resolved] Slow uploading speed to Vertica

Anonymous — Thu, 11 Feb 2016 12:45:02 GMT

Hi
When i use in my job some tMSSQL_Input and try to get some data to my HP Vertica output, the speed of rows are so slow! Not more 8-9 in sec. I use Open Studio 6.1.1, before I used version Talend 5.5.1, the speed is beign good. What's the problem?
Thank you!

Re: [resolved] Slow uploading speed to Vertica

Anonymous — Thu, 11 Feb 2016 17:03:29 GMT

Hi Woo,
As far as I know there would not be much difference in terms of performance in 5.x and 6.x. Kindly check with your commit rows and increase if required!!
Useful URL : https://www.talend.com/ecosystem/company/hp-vertica

Re: [resolved] Slow uploading speed to Vertica

Anonymous — Thu, 11 Feb 2016 20:36:12 GMT

Vertica likes to load rows in bulk. That said, what is your configuration for the tVerticaOutput component (Advanced settings)?
There could be other factors at play, such as network speed.
See Vertica Tips and Techniques for Talend

Re: [resolved] Slow uploading speed to Vertica

Anonymous — Fri, 12 Feb 2016 10:41:08 GMT

Vertica likes to load rows in bulk. That said, what is your configuration for the tVerticaOutput component (Advanced settings)?
There could be other factors at play, such as network speed.
See Vertica Tips and Techniques for Talend

Thank you very much!
The problem is resolved by the clicking checkbox on "Use batch mode". In my last version of Talend wasn't this checkbox