I got a question asking why the integrated replicat starts to show long lag time after a large transaction is committed. To answer this question, I write a blog to discuss how to tune the performance of Integrated Replicat (also called Integrated Delivery). In summary, Integrated Replicat is optimized for a large number of small transactions. To optimize its performance, you can:
[Read More]
- Making smaller transactions or use the eager apply feature
- Optimizing the processing within the transaction using BATCHSQL
- Avoiding having direct apply
- Putting direct apply operations into smaller transactions or grouping them into a separate replicat.
[Read More]