I am doing a reload of a large dialect 1 Firebird database to a dialect 3
Firebird database. I am using the TIB_Datapump component and seem to have
everything working pretty well until I hit the very large tables. They fly
thru the first 50 - 60 thousand rows but then slow down considerably and
sometimes stop. I believe I need more commits, maybe every 500 rows or so.
How do I do those commits? After the TIB_DataPump Execute is called how can
I add commits?



What I am doing--



trn.StartTransaction;

try

curdb1.Prepare;

dsqldb3.Prepare;

pump.Execute;

trn.Commit;

except

trn.Rollback;

raise;

end;



IBO 4.8.5

Firebird 1.54





[Non-text portions of this message have been removed]