Performance Best Practices for Database Loader
To obtain optimum performance when using Database Loader, consider the following points:
- Create Indexes which are shipped with the product as part of Seed Data.
- Create Indexes on data source as mentioned in Data Source Indexes.
- Create separate tablespaces or datafiles for large TIBCO MDM tables and Indexes. For information, refer to Tablespaces Configuration and Database Optimizations on Microsoft SQL Server - Customer Study.
- Disable logging on the Oracle database for the following tables:
Copyright © Cloud Software Group, Inc. All rights reserved.