topic Re: DBInput_Postegres - to slow in Talend Studio

DBInput_Postegres - to slow

Anonymous — Wed, 15 May 2019 08:27:54 GMT

Hello all,

I have an inputPostgres, but is to slow to starting getting the rows and then is getting more less 300 rows/sec, so I have 7 millions of rows to read, is not possible, it has to be faster.

Anyone can help me?

Thanks.

Re: DBInput_Postegres - to slow

Anonymous — Wed, 15 May 2019 23:37:46 GMT

Hi,

Could you please try the method of using tparallelize and then extracting data for different partitions simultaneously? You can merge the data set later for further processing.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

Re: DBInput_Postegres - to slow

Anonymous — Fri, 17 May 2019 11:16:37 GMT

Hello, is a network issue, I was running in my laptop when I install in a production environment took less time.

By the way, I'm working with a Taled Open Studio, I don't have parallelism.

Thanks anyway.