Thanks Jason for the complement ! In my case its just a copy, so no
deletes on the source.

[]s

Carlos
WarmBoot Informatica - http://www.warmboot.com.br
Interbase-BR - http://www.interbase-br.com

JCJ> Carlos,

JCJ> One other thing. If you are pumping the data in a
JCJ> Destination: Insert
JCJ> Source: Delete
JCJ> Then using a joint DB transaction is pretty important to guarantee no
JCJ> missing data or double entries.
JCJ> If just:
JCJ> Destination: Insert
JCJ> Then I would use a TX for each DB as it will reduce the possibility of Limbo
JCJ> Transactions if either server crashes. Finally, if you use 2 tx's you can
JCJ> also make the application multi-threaded and may get perf benefits from
JCJ> having 1 worker thread reading the data and multiple worker threads
JCJ> inserting the data (each thread needs its own connection).

JCJ> Cheers,

JCJ> Jason Chapman
JCJ> JAC2 Consultancy

JCJ> Training - Development - Consultancy
JCJ> Delphi, InterBase, Firebird, OOAD, Development lifecycle assistance,
JCJ> Troubleshooting projects, QA.....
JCJ> www: When I get round to it....
JCJ> Mob: (+44) 07966 211 959 (preferred)
JCJ> Tel: (+44) 01928 751088

JCJ> ""Ann W. Harrison"" <aharrison@...> wrote in message
JCJ> news:5.1.0.14.2.20021014145108.02a4ed90@......

>> 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.
>>
>>
>>
>>
>> To unsubscribe from this group, send an email to:
>> ib-support-unsubscribe@egroups.com
>>
>>
>>
>> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>>
>>
>>

JCJ> To unsubscribe from this group, send an email to:
JCJ> ib-support-unsubscribe@egroups.com



JCJ> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/