If the Maximum Database Connections setting in Product Options is greater than one, you can increase the number of concurrent database connections for an Archive, Extract, or Delete Process. Increasing database connections improves performance when processing large quantities of data by allowing multiple threads to process rows in parallel.
Only tables with unique indexes are processed in parallel. Increasing the number of database connections to process small amounts of data may decrease Archive and Extract performance rather than increase it, however.
You can use up to four database connections for each processor on your Optim™ Server. For example, if your Server has two processors, then you can use as many as eight database connections for each process. For performance reasons, you must select an even number of database connections.
Click Database Connections on the General tab of the Archive Request Editor or Extract Request Editor to increase the maximum number of connections and select an even number, up to the site maximum.
Click Database Connections on the General tab of the Delete Request Editor, or the Delete tab of the Archive Request Editor, to increase the maximum number of connections. Select an even number up to the site maximum.