About Importing and Exporting Data

INSERT is described in Data Manipulation Statements and is the slowest load approach. MySQL Loader can provide better performance than INSERT, and is well suited to loading files when conditions such as detailed error handling and broader support for input file format are required. The Hyperstage Loader is the fastest load method, but supports less load syntax.

WebFOCUS Hyperstage Loader

The advantages and disadvantages of using the Hyperstage Loader are:

Fastest loader.
Less error handling diagnostics (only the source file row number pertaining to the error is returned).
Strict input file formats (supports delimited text and binary formats).
Less tolerant of load file errors than the MySQL Loader.

Note: The Hyperstage Loader can only be used to import or export data to or from Hyperstage tables.

MySQL Loader

The advantages and disadvantages of using the MySQL Loader are:

Slower than the Hyperstage Loader.
More robust error handling.
Broader text input file support (including fixed length formats).

INSERT

The advantage and disadvantages of using INSERT are:

Supported by virtually all ETL tools.
Can be very slow depending upon the approach and commit rate.

If you are using an ETL tool, then using the Hyperstage Loader with the binary format would be most efficient although this approach may require more data preparation. We recommend for large fact tables, the Hyperstage Loader should be used with either binary or text input. For smaller tables or dimension tables, the MySQL Loader can be used successfully.

You can load data into Hyperstage tables using the standard MySQL loading command and export data using the standard MySQL export command. You must set several parameters before importing or exporting data.