D
Dmitri Levin
Guest
Thank you very much Valeriy 1. "split replication threads" I will change the RANDOM(2.5) to use some version of RECID (modulo). We are not going to upgrade to version 5, as I heard Pro2 version 6 should be released soon. 2. "compression trigger" tplt_repltrig_with_compression.p I do not think that will work with ver 4 pro2 repl DB schema. The following code requires an index FIND FIRST ReplQueue WHERE ReplQueue.SrcDB = " >" AND ReplQueue.SrcTable = " >" AND ReplQueue.SrcRecord = strRecID EXCLUSIVE-LOCK NO-WAIT NO-ERROR. And in ver 4 there is there is no index supporting that FIND. With thousands ReplQueue records that FIND will work very slow and kill the system. May be in ver 5 that "compression" logic is done better than in ver 4. The idea is very good.
Continue reading...
Continue reading...