[Progress Communities] [Progress OpenEdge ABL] Comment on Enhancement for Pro2 with CDC replicating large tables.

  • Thread starter Thread starter Valeriy Bashkatov
  • Start date Start date
Status
Not open for further replies.
V

Valeriy Bashkatov

Guest
In addition, I found that when creating records in the replqueue table, the CDCAdminProcess.p process (Line 978) uses the WHOLE-INDEX search. My tests showed that it's enough to add forced use of the idxSrcRecord index for that query: FIND LAST {&REPLDB}ReplQueue WHERE {&REPLDB}ReplQueue.SrcDB = ttReplTableInfo.SrcDB AND {&REPLDB}ReplQueue.SrcTable = ttReplTableInfo.SrcTable AND {&REPLDB}ReplQueue.SrcRecord = strRowid AND {&REPLDB}ReplQueue.Applied = FALSE use-index idxSrcRecord EXCLUSIVE-LOCK NO-WAIT NO-ERROR. After that, the performance of the CDCBatch processes increased significantly. But I have to keep this in mind when I update Pro2 next time. And we still need an index for _cdc-change-tracking._User-Misc field.

Continue reading...
 
Status
Not open for further replies.
Back
Top