Really Slow load from Informix Database (version 7.3)

[Anonymous]

Hello!

I would like help with a really big problem that I am facing right now, I have load data from an Informix database but Talend can't load more than 70 rows per second, if I try to load in this same database from Excel or Qlik I can read it at least 8 x faster.

Could someone help me with that?

[Anonymous]

Could you share your schema? Maybe I am get a wrong data type. What's is your jbdc driver version ?
I

[vapukov]

I just create and populate table with 1M rows, as you describe:

- serial - primary key

- integer - random

- integer random

- varchar - 255 char random 

and use standard talend components - int, int, int, string

[Anonymous]

It is wired I have used the same data types as you.....
In the same server I have different performance to load the data depends on the tool.
I really don't know how fix it...
Maybe the version of the informix 7.3

[vapukov]

yes, it could be and settings and version (I have the latest) and network - my is local 1Gb network 

[Anonymous]

I have the database In the same network, i don't believe this is the reason...
As I said before, the wired thing is I have a good performance In the same table delwnd the field I retrieve

[Anonymous]

I have tested with Pentaho and get better performance, but I would like to do it in Talend, someone I am convinced that the problems are about the Data formating between Talend and Informix

[Anonymous · Accepted solution]

The problem was the limitation from Informix to retrieve the data, you have to set the variable FET_BUF_SIZE to improve the performance. more details here
https://community.talend.com/t5/Design-and-Development/Problems-to-connect-Informix/m-p/159228#M9718...

I really thanks to @vapukov