Archive uses 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, since an increased buffer size can also hinder performance by affecting memory usage, the buffer should be set to the lowest value that also provides maximum performance.
When multiple database connections are used, Archive allocates the buffer size equally across the connections. If the number of database connections is increased, Archive 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. The default value is recomended unless you are processing tables larger than 10 000 rows.