-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Bogusław Brandys wrote:

> Hi,
>
> I'm not sure if this should take so long to process and that's why I
> must ask:
>
> Using Windows XP Home SP2 , Firebird Superserver 1.5.2
> MS SQL Server Express database is on the same computer.
>
> I'm importing not so large database from MS SQL Express. Database is
> about 2,1 Gb in size.There is one table with a few milions of rows and
> the second table has more then 100 milions rows (and is connected to
> the first by FK (One to Many relation)).
> Data pump is done using IBDataPump utility directly using some not so
> complex SQL (but not direct table->table)

OK.After removing all indexes and contraint (PK,FK) and disable triggers
I can import three milions of records during 1 hour :-)

Now I'm wondering how long does it take to recreate all indexes and
constraints.


Regards
Boguslaw

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.0 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFCvElktuGICzHOh+YRArmHAJkBKHW/bm9emhQzeWCtZ/nf9Bv1zQCdHzwP
EKClpemPr4hyg7zhGcIlCak=
=lvBy
-----END PGP SIGNATURE-----