High-Performance Loader performance advantages for large databases
The High-Performance Loader (HPL) utility, which can load data from any ASCII or COBOL file that meets certain format prerequisites, uses parallel processing to perform fast data loading and unloading. However, the HPL requires significant preparation time.
For extremely large databases, the HPL has a performance advantage over other IBM® Informix® data-migration utilities because it performs I/O and code-set conversions in parallel. Use the HPL only for large databases, for which the time savings in the actual loading or unloading of data makes the preparation time worthwhile.
The following HPL features provide powerful tools for handling
data from non-Informix sources:
- Drivers to handle different database types
- Filters and functions to manipulate data
- Code-set conversion
- The ipload GUI for UNIX
- The onpladm command-line utility for UNIX and Windows
For more information about the HPL, refer to the IBM Informix High-Performance Loader User's Guide.