Skip to Content
1
Former Member
Aug 13, 2008 at 03:46 PM

Speed-up loadercli data import run?

83 Views

Hi all,

I do not know if a similar one was posted before (I did not find..)..

We are just migrating schema data from one MaxDB to another (both v7.6) using the loadercli with loader command files (pls. see command extracts below) that export the schema data table-wise, and then import the table data into the new DB again (in order to cover look-up relations via FKs). The export takes ~12min while the import takes 3h. - There is a very long table (6.4mio rows) included. But this import duration lasts too long!

Is there any possibility to speed-up this loadercli import (like e.g. Oracle SQL*Loader's direct load without parsing..)?

-Thanks in advance!

kind regards

Frank

Export loader command:

EXPORT TABLE <schema>.<table>

DATA OUTSTREAM FILE '<path>\<export_data_file>'

RECORDS

NULL '?'

DATE ISO

TIME ISO

TIMESTAMP ISO

DECIMAL '/./,/'

BOOLEAN 'TRUE/FALSE'

PACKAGE OUTSTREAM FILE '<path>\<package_file>'

CSV

NULL '?'

DATE ISO

TIME ISO

TIMESTAMP ISO

DECIMAL '/./,/'

BOOLEAN 'TRUE/FALSE'

//

Import loader command:

IMPORT TABLE <schema>.<table>

REJECT DUPLICATES

DATA INSTREAM FILE '<path>\<export_data_file>'

RECORDS

NULL '?'

DATE ISO

TIME ISO

TIMESTAMP ISO

DECIMAL '/./,/'

BOOLEAN 'TRUE/FALSE'

PACKAGE OUTSTREAM FILE '<path>\<package_file>'

CSV

NULL '?'

DATE ISO

TIME ISO

TIMESTAMP ISO

DECIMAL '/./,/'

BOOLEAN 'TRUE/FALSE'

//