Hi,
I use TIB_DataPump and IB_cursor to insert data into a database (a
empty one created with backup and restore only metadata).
As I have Tables with about one hundrer thousand records, I perform a
commit retainning on after execute event. When looking to statistics,
I see then next transaction counter growing.

How can I improve inserting ? Is there a counter I could use, for
doing a commit every 1000 inserts ?

I have seen in forums, somebody's speaking of inserting thousand's
insert a second, but even when doing insert without IB_DataPump and
committing every 1000 insert, I can't go further 400 inserts a second
with 2 fields table. Should I use virtual disk for temporary files,
disable forced write and enable it after inserts done ?

Thanks for your suggestions