Factors That Affect Performance When Performing a Large Load

The following information relates to performance and sizing concerns:

• Throughput characteristics between different record types and scenarios vary widely, therefore it is not possible to predict the throughput rate for a given load.

• Optimization is an iterative process which builds from a single session test to large scale concurrency testing.

• It is your responsibility to act on your data. Oracle does not update, delete, or otherwise alter customer data.

• Staging and production environments are not identical, therefore throughput can differ between these two environments.

• Oracle Data Loader On Demand uses nonsequential processing. This provides for maximum throughput by using all available resources to import your data. For example, if your server has four tasks available and you submitted a 4000-record import, and if no one else was importing data, then Oracle Data Loader On Demand would use all four tasks to import the 4000 records (each task importing 1000 records). If this job was processed using a sequential process, then only one task would be used and the other three would be idle.

• For better performance when importing, consider inactivating any workflows that can be postponed.