Comparison item | pd_dbsync_altwrite_skip operand value |
---|
Y | N |
---|
Database writing method when an update buffer reference request is issued during synchronization point acquisition processing | The server process that will execute the transaction that issues the reference request does not handle writing of the update buffer contents into the database. (The handling is skipped.) | The server process that will execute the transaction that issues the reference request handles writing of the update buffer contents into the database. (The handling is not skipped.) |
Advantage | Because the server process that will execute the transaction does not handle the write processing, the performance of the referencing transaction is stable during synchronization point acquisition processing. | The amount of time required for synchronization point acquisition processing is reduced because some of the workload is distributed to the referencing transaction. |
Disadvantage | The amount of time required for synchronization point acquisition processing increases because none of the workload is distributed to the referencing transaction. | There might be adverse effects on the referencing transaction during synchronization point acquisition processing. |