| Subject | Re: Load table |
|---|---|
| Author | Thomas |
| Post date | 2011-02-13T23:56:51Z |
--- In firebird-support@yahoogroups.com, "ezzodder@..." <ezzodder@...> wrote:
With a JDBC based tool that uses batched statements it takes about 5 minutes to load 1.5 Million rows into a sample table on my laptop.
The table is relatively narrow (only 5 varchar columns) though.
This is with a default installation of Firebird 2.5 on a Windows XP 32bit laptop. So the harddrive isn't very fast either.
>Depends on what you consider "a very long time".
> 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.
With a JDBC based tool that uses batched statements it takes about 5 minutes to load 1.5 Million rows into a sample table on my laptop.
The table is relatively narrow (only 5 varchar columns) though.
This is with a default installation of Firebird 2.5 on a Windows XP 32bit laptop. So the harddrive isn't very fast either.