System configuration setting DatabaseInsertBatchLimit is used to determine how RPI undertakes the insertion of records into the audience and offer history tables.
If set to a value greater than 0, the insertion of records will take place in ‘chunks’, with the maximum number of records inserted at a time being accordant with the setting’s value, and, potentially, a number of separate SQL statements being executed to complete the insert.
If set to 0, no chunking takes place, with insertion of records being carried out en masse. This has the effect of executing a single SQL statement, but one that has the potential to be longer-running and more resource-intensive.
Note that, if running against a DB2 data warehouse, DatabaseInsertBatchLimit will also apply to inserts into all of the following database tables:
•Dataflow_*
•RP_BC_*