Performance tips for importing data
Although importing large volumes of data can be time consuming, there are a few things you can do to save time:
- Place data files on a separate physical disk drive from the database. This could avoid excessive disk head movement during
- Extend the size of the database. This command allows a database to be extended in large amounts before the space is required,
rather than in smaller amounts when the space is needed. As well as improving performance for loading large amounts of data,
it also serves to keep the database more contiguous within the file system. See ALTER DBSPACE statement.
- Use temporary tables to load data. Local or global temporary tables are useful when you need to load a set of data repeatedly,
or when you need to merge tables with different structures.
- If you are loading using the LOAD TABLE statement, do not start the database server with the -b option (bulk operations mode).
- If you are using the INPUT or OUTPUT statement, run Interactive SQL or the client application on the same computer as the
database server. Loading data over the network adds extra communication overhead. You may want to load new data at a time
when the database server is not busy.