At 03:33 PM 10/14/2002 -0300, Carlos H. Cantu wrote:

>Hello !
>
>Does anybody had played with this :
>
>When doing a Pump between 2 databases, what is the best option
>regarding performance : Keep both of them sharing the same transaction
>or keep separated transactions for each one ?

In theory, it should make no difference. If you have a common
transaction, all it does is coordinate operations between child
transactions, one in each participating database. So there's
slightly less overhead if you open a transaction in each database.



Regards,

Ann
www.ibphoenix.com
We have answers.