Direct Load Import

Direct load import depends on the following factors:

• CPUs available for processing records in parallel: if the CPU resources on a TIBCO MDM instance are available, you can increase the pool size of the asynchronous queue or the number of TIBCO MDM instances.
• Preloaded data: this has a pronounced impact when the data you are importing are modifications of existing records. Preloading does not noticeably improve the performance when you import new records.
• Database: the database insert performance could be a limiting factor. Insert performance depends on the number of indexes, the file system, and the partitioning strategy.
• Database parameters: TIBCO recommends that you review the Review advisories generated by Oracle, SGA, and PGA focusing on sizing.

Copyright © Cloud Software Group, Inc. All rights reserved.