To improve performance when you process large quantities of data, increase the number of database connections to allow multiple threads to process rows in parallel.
To enable multiple database connections for an archive, extract, or delete process, set Maximum Database Connections in Product Options to a value greater than one. The size of the buffer increases according to the number of database connections that you allow.
For best performance, experiment with a small number of database connections and increase the number gradually. Performance can degrade if you allow too many database connections for the number of processors that are available. Performance might also degrade if you increase the number of database connections to process small amounts of data.
Multiple threads are activated when there are more than 10,000 keys for the tables. Only tables with unique indexes are processed in parallel.
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.
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.
In an archive or extract process, the start table is processed in parallel only if a point-and-shoot list is specified. Using multiple threads, a number of rows are extracted concurrently from a single table. Data is not extracted simultaneously from multiple tables, however.
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.
Multiple tables can be processed in parallel, but only one connection is opened per child table. In a delete process, requests with 1000 or more rows are processed in parallel unless there are relational integrity (RI) constraints. Multiple threads (one per table) delete rows concurrently from multiple tables in the database. If Lock Tables is selected, tables are not processed in parallel.