Performance Tools

Archive provides various features and tools to complement the processing strategies that you establish to best enhance performance at your site. Using these features you can better diagnose and configure Archive to more successfully process your database tables.

Statistical Reports
Add performance information to the Archive, Extract, or Delete Process Report to analyze the best method to improve performance. For example, based on information in these reports, you may decide to change the method used to access a database table, increase the number of keys looked up at one time, or create an index for a key column.
Table Access Strategy
Archive generally uses a key lookup when a DBMS index is available and a scan when an index is not available. If accessing a significant portion of the table, however, Archive will use a scan, even if an index is available.

You can override the default strategy:

  • For an Archive (or Extract) Process you can override the default method of accessing the parent or child table for each relationship and limit the number of key lookups performed at one time for the parent or child table in each relationship.
  • For a Delete Process, you can override the default method used to delete rows from the database and limit the number of key lookups performed for each table.
Index Analysis
For an Archive (or Extract) Process, analyze DBMS indexes for relationships, if needed to Archive (or Extract) rows in the Access Definition. Additionally, create new indexes for the relationship, if needed.

For a Delete Process, analyze DBMS indexes for tables in the Source File, and create new indexes, if needed.

Multiple Database Connections
Increase the number of connections to the database for the Archive or Delete Process to process rows concurrently.
Buffer Size Limit
Set the buffer size to use when fetching or deleting rows from the database.
Ignore Empty Relationships
For an Archive (or Extract) Process, exclude any rows with a relationship value equal to empty, null, zero-length or a specified numeric. See the Common Elements Manual section on Access Definitions for details.