How to tune the performance when use an existing connection?

[Anonymous]

Hi Guys,

I would like to do the performnace tunning when use an existing connection. If we are using the repository or built-in database connection. That we can change the commited size. But if we use an existing connection that we only can change the insert parameter: batch size in advanced option. 

So some time, we got the slowly insert in the target DB. Could anyone know how to tuning the performnace on the this mode?

Thanks.

Jowvid.

[fdenis]

did you ask this question to your dba?
is there maintenance Plans on your bd? is there locks? …. there is a lot of possibility.