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.