Improving IDENTITY
Replication with Array Processing
Because only one table per session can have IDENTITY_INSERT
set to ON
, Replicat must continuously toggle IDENTITY_INSERT
when it applies IDENTITY
data to multiple tables in a session. To improve the performance of Replicat in this situation, use the BATCHSQL
parameter. BATCHSQL
causes Replicat to use array processing instead of applying SQL statements one at a time.