I am experiencing performance issues when I use the tDBConnection component (associated to tDBInput & tDBOutput) on large volumes of data (instead of classic way with Metadata/Repository). Is this bug known?
Do I have anything special to configure in the project ? or the job ? I tested with and without auto-commit, it's about the same.
if you are using dbconnection for 2 components one select one update, it may take more time due to single way , try to add a second connection only for select.
if you are using dbconnection for 2 components one select one update, it may take more time due to single way , try to add a second connection only for select.
