henry FRANQUET wrote:

> --- In IBObjects@yahoogroups.com, Aage Johansen <aagjohan@o...> wrote:
>
>>henry FRANQUET wrote:
>> > 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.
>
> ...
>
>> I haven't used the Datapump, but TIB_DSQL is quite fast when you're
>> doing simple inserts (and otherwise, as well).
>
> I'll try to replace my TIB_Cursor with a TIB_DSQL

Don't. This is just for when you do the inserts yourself (not using a tool
llike DataPump), you would then select with the TIB_Cursor and insert with
the TIB_DSQL. With separate transaction you could commit the insert
transaction, but it shouldn't really be necessary.
I have no experience with the datapump myself so I cannot comment upon its
general speed. Maybe you could ask Svein Erling for a copy of his program
for transferring records from one Fb/IB database to another...


Did you check for any Hyperthreading or multi-CPU issues?


--
Aage J.