Do you COMMIT every single record or do you COMMIT at the end of the
transfer? Maybe you should experiment with that (commit after each
record, after each 100th record, etc.).

You could also take a look at External Tables.

There will be improved features for Bulk Inserts in Firebird 2.1 IIRC.


Regards

Stefan

> Hi all

> I have a big performance issue. My infrastructure looks like this:

> I have a central Oracle database where I host all data for my salesreps

> Each SalesRep has a laptop with Firebird running. Now I have to
> download data from Oracle to each Laptop day by day.

> I have a program done with Delphi. This inserts row by row and this
> takes to long.

> What's the fastest way to make a Batchmove from Oracle to Firebird?

> Herbert



> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !

> Also search the knowledgebases at http://www.ibphoenix.com

> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links