Optim™ solutions use a buffer that stores extracted rows during a fetch process and primary keys during a delete process. When the buffer size is increased, the number of rows processed per second is also increased. However, an increased buffer size can also hinder performance by affecting memory usage.
When multiple database connections are used, Optim solutions allocate the buffer size equally across the connections. If the number of database connections is increased, the solution multiplies the buffer size by the number of connections.
You can set a buffer size from 64K to 1024K and increase the value by 32K increments. The default buffer size is 512K. Generally, use the default value unless you are processing tables larger than 10,000 rows. For large tables, increase the buffer size gradually until no further performance gain is realized.
To set the buffer size for an extract or archive process, select Fetch Buffer Size in the Database tab of Product Options.
To set the buffer size for a delete process, select a Delete Buffer Size in the Database tab of Product Options.