Hi,
i don't have the same structure and i must do some operation when import the
data, then a standard Datapump utility don't solve my problem.

But why the insert/post on Firebird are so slow?

Regards,
Enrico Raviglione.



-----Messaggio originale-----
Da: Kaputnik [mailto:delphi@...]
Inviato: giovedi 28 febbraio 2002 12.41
A: IBObjects@yahoogroups.com
Oggetto: RE: [IBO] Faster Datapump from FoxPro/Paradox to Firebird


There is IBDatapump out there, which does most stuff automated.
As long as you create a table-structure identically in your IB-DB and
the old Paradox db, IB Datapump can even map all tables and fields
automatically.

You can find it on http://www.clevercomponents.com

Its pretty fast, and as it is automated, your 200MB tables can be pumped
over night in one batch run.

CU,

Nick Josipovic

BIT Institute
Prof. Dr. Franz Steffens
University of Mannheim
T: ++49 621 181 1621
M: ++49 179 133 44 16
S: ++49 621 181 1622
F: ++49 621 181 1618

nick.josipovic@...

> -----Original Message-----
> From: Enrico Raviglione [mailto:e.raviglione@...]
> Sent: Thursday, February 28, 2002 12:44 PM
> To: 'IBObjects@yahoogroups.com'
> Subject: [IBO] Faster Datapump from FoxPro/Paradox to Firebird
>
> 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
>
>
>
> ------------------------ Yahoo! Groups Sponsor
>
>

________________________________________________________________________
__

> _
> 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/