Subject | Re: Load table |
---|---|
Author | ezzodder@rocketmail.com |
Post date | 2011-02-13T21:02:13Z |
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?
Mike
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?
Mike