Tune Bulk Loading of Data

Loading large volumes of data into a database can take a long time and use a lot of disk space. There are a few things you can do to save time.

• Load Performance During Database Definition
  The way you define your database, tables, and indexes can have a dramatic impact on load performance.
• Load Time Environment Adjustments
  When you load data, you can adjust several factors to improve load performance.
• IQ Main Store Space Use in Incremental Loads
  An incremental load may modify a large number of pages within the table being loaded.
• Thread Use During Loads
  When possible, Sybase IQ uses multithreading to improve load performance.