Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Talend tDBInput Dynamic Schema Much Slower than Static

I'm designing a Talend job that uses dynamic SQL to generate an output. The trouble I've found that a static defined schema is much faster than the dynamic schema. Is there some configuration that needs to be adjusted in the job to increase throughput?  The below is the same query using a dynamic schema and static schema. The static schema can actually go faster than shown but the dynamic maxes out at 5-7 rows a second.

 

0683p000009MaAO.jpgDynamic Schema0683p000009Ma8k.jpgStatic Schema

 

 

Labels (3)
0 Replies