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.