On 2/13/2011 4:02 PM, ezzodder@... wrote:

> Milan,
> I am in a similar situation. I have dozens of MySQL tables that I would like to import into Firebird 2.5. Each table has anywhere from 5 million to 35 million rows of data. All of the products mentioned in this thread use Firebird's "Insert" statement to load the data. I suspect this is going to take a very long time to complete.
>
> Doesn't Firebird have a batch load command like MySQL's "Load Data Infile" or PostgreSQL's Copy command?
>

If your data happens to be in fixed length columns (as opposed to csv or
some other format) you can define the input file as an external table
and use an INSERT ... SELECT

Failing that, prepare the insert and just send the data to avoid having
to recompile the statement for each row.

Good luck,

Ann