Subject Performance problem with IB_Datapump
Author Robert martin
Hi All

We are noticing a major performance problem when using the Ib_Datapump
component. On some machines this is taking an extreme amount of time to
complete (hours) but on others the performance is as expected.

Example results

86MB Database (note that all tables are pumped than further processing
occurs, the extra processing takes the expected amount of time on all

Machine Time

AMD Athalon XP 2400+
512MB Ram 17minutes

AMD Athalon 64 3000+
1GB Ram 12minutes

P4 3000
768MB Ram 12hrs

Dual CPU Xenon 3000 (?)
1 GB Ram (perhaps more) 48hrs

The common theme appears to be p4 CPUs causing problems. The P4 3000
does not have hyperthreading enabled (I will check this further) so
probably the issue is not related to this. The Pump is using Ib-Cursors
for source and Dest and is contained in its own transaction for each
table. The performance lag occurs during the Ib_Datapump.execute method.

Any suggestions would be greatly appreciated.

Rob Martin
Software Engineer

phone +64 03 377 0495
fax +64 03 377 0496
Wild Software Ltd

No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.300 / Virus Database: 265.6.10 - Release Date: 10/01/2005