Goldengate BATCHSQL

如果生產環境的Goldengate不需要實時同步的話，那末我們可使用BATCHSQL這個參數進行批量同步，從而提高goldengate的性能

Valid for Replicat
Use the BATCHSQL parameter to increase the performance of Replicat. BATCHSQL causes
Replicat to organize similar SQL statements into arrays and apply them at an accelerated
rate. In its normal mode, Replicat applies one SQL statement at a time.
BATCHSQL is valid for:
● Oracle
● DB2 LUW
● DB2 on z/OS
● Teradata
● SQL Server


How BATCHSQL works
In BATCHSQL mode, Replicat organizes similar SQL statements into batches within a
memory queue, and then it applies each batch in one database operation. A batch contains
SQL statements that affect the same table, operation type (insert, update, or delete), and
column list. For example, each of the following is a batch:
● Inserts to table A
● Inserts to table B
● Updates to table A
● Updates to table B
● Deletes from table A
● Deletes from table B

For Example：

生活不易，碼農辛苦
如果您覺得本網站對您的學習有所幫助,可以手機掃描二維碼進行捐贈