Thank's to all,
now i go to try all your suggestion.

Regards,
Enrico Raviglione.


-----Messaggio originale-----
Da: H.Klomann [mailto:nibler@...]
Inviato: giovedi 28 febbraio 2002 14.04
A: IBObjects@yahoogroups.com
Oggetto: Re: [IBO] Faster Datapump from FoxPro/Paradox to Firebird


Enrico,

check out this :

procedure TForm1.PumpClick(Sender: TObject);
begin
Table1.Open;
Table1.First;
IB_DSQL1.SQL.Clear;
IB_DSQL1.SQL.Add('insert into T (FIRST_NAME,LAST_NAME) values
(:FIRST_NAME,:LAST_NAME)');
IB_DSQL1.Prepare;
while not Table1.Eof do begin
Table1.Next;
IB_DSQL1.ParamByName('FIRST_NAME').AsString :=
Table1.FieldByName('LAST_NAME').AsString;
IB_DSQL1.ParamByName('LAST_NAME').AsString :=
Table1.FieldByName('LAST_NAME').AsString;
IB_DSQL1.ExecSQL;
end;
// no AutoCommit !!
IB_Transaction1.Commit;
end;

Bevor, consider to deactivate your Indexes on your destination table !
Do you have any triggers active on destination table ?

This should be speed up your import.

Harald




Enrico Raviglione schrieb:

>
> Hi to all,
> i must import into a new Firebird DB all the old data stored into a FoxPro
> or Paradox table.
> I have a procedure with a TIB_Cursor and a TTable for make this and all

work

> fine but the process are very slow, an example:
> for a table of only 630 record and 15 columns an Athlon 700Mhz in cpLocal
> connection work about 2 minutes!!
>
> Can i accelerate the process?
>
> I must import some large table (about 200MB) for every installation and at
> this speed it's very frustrating...
>
> Regards,
> Enrico Raviglione
>
>
>

___________________________________________________________________________

> IB Objects - direct, complete, custom connectivity to Firebird or

InterBase

> without the need for BDE, ODBC or any other layer.
>

___________________________________________________________________________

> http://www.ibobjects.com - your IBO community resource for Tech Info

papers,

> keyword-searchable FAQ, community code contributions and more !
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

___________________________________________________________________________
IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________
http://www.ibobjects.com - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

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