tDBConnecion and tDBClose

[Anonymous]

Hey Community ,

I have a basic question , actually i run a simple project with 20 jobs . I use many TDBInput and tDBOutput in each job and it works .My question is  what  is the meaningful use of tDBConnection and tDBClose in a job ? If i initialize and close the connection , it will be advantagious to my jobs ?

[Anonymous · Accepted solution]

Hello,

We are supposing that you have already checked online cmponent references about:TalendHelpCenter:tDBConnection and TalendHelpCenter:tDBClose.

DB connections are a way to reuse the connectivity between database and Talend especially when the transaction need to be either committed or rollbacked in one shot. In an ideal method, if you can reuse the connection for collecting data from multiple tables (especially for lookups), then you should go for it. If you are connecting one connection for every table lookup, it is nothing but individual connection made through the component itself. It depends on your selection and please see the performance of the connections and DB queries using DB utility tools also. This will give the performance of each connection and show the corresponding performance.

Best regards

Sabrina