[Stackoverflow] [Progress OpenEdge ABL] OpenEdge Replication - Time to Replicate?

[Raphael Frei]

For the last couple days, I've been monting a structure to apply replication across 3 databases (Will be more than 20 in the next couple months).

The replication process is OK, both databases (Source and Target) are communicating. The databases aren't very big - The largest one has 30GB and the smallest has 300MB.

But I've noticed that it takes about 10-15 seconds from a record from source to appear on target database (On the 300MB).

Is there a parameter that we can change to make this faster? We are not using TRANSITION right now, so the migration process is manual.

Here's DB startup parameter:

CALL %DLC%\bin\_mprosrv %GSFSPATH%\%GSFSDBFILE%.db -ld gsfs -S %JTDSPORT% -Mf 6 -B 2680 -n 90 -Mn 47 -Mpb 44 -Mi 5 -Ma 5 -Mm 16384 -bibufs 50 -aibufs 75 -L 9000 -N tcp -spin 10000 -minport 5000 -maxport 65000 -omsize 8192 -prefetchDelay -prefetchFactor 100 -prefetchNumRecs 100 -prefetchPriority 100 -lruskips 100 -lru2skips 200 -aiarcdir %AIDIR%\%GSFSDBFILE% -aiarcinterval 1800 %DBSERVICE_PARAM% -pica 8192

It also loads APW, WDOG, BIW and AIW.

And the REPL.PROPERTIES:

[server]
   control-agents=agent0
   database=E:\path\db
   agent-shutdown-action=recovery
   transition=manual  
   
[control-agent.agent0]
   name=agent0
   database=E:\path\db
   host=SOURCE_IP
   port=40014
   replication-method=async
   connect-timeout=300
   critical=1

[control-agent.agent1]
   name=agent1
   database=E:\path\db
   host=TARGET_IP
   port=40014
   replication-method=async
   connect-timeout=300
   critical=1

[agent]
   name=agent1
   database=E:\path\db
   listener-minport=4300
   listener-maxport=4500
   transition-timeout=300
   rsb-cache-size=5000

Continue reading...