Replication of a databases to a local client takes very long time.
We have the following details:
-
at the start there is rather much network traffic, which indicates data is received from the server
-
after a couple of minutes network traffic is nearly reduced to 0%. It gives the impression data is processed locally on the client
-
after the network traffic is nearly reduced to 0%, you might expect there is a lot of Disk I/O or CPU load, however the opposite is the case
-
For ca. 7000 documents, it takes about 2 hours before the replication is completed
-
Deletion stubs have been removed already from the database
Is there a way to give background replication more computer resources to complete the task?
Subject: There are a number of pieces that are missing
I think most can be answered by turning on CLIENT_CLOCK=1 and DEBUG_CONSOLE=1 to get that output.
Things of interest:
How big is the database?
Does this happen on the 1st replication or all replication?
If all, does the 1st replication ever completely success, that is if they look in the log, are there any errors. On errors, the search will get repeated.
For the times it takes a long time, what part of replication is occurring: search? Copy?
What are the version of the client and the server?
How much will get replicated? How fast is the connection?
For example, a replicaiton of a 20 Gb mail file over a cable mode, the 1st time will take a while.
Subject: Details about slow replication
How big is the database?2200 MB
Does this happen on the 1st replication or all replication?
1st replication takes double time. The details are about the 2nd and following replications.
If all, does the 1st replication ever completely success, that is if they look in the log, are there any errors. On errors, the search will get repeated.
The log does not show errors. The replication is completed successfully.
For the times it takes a long time, what part of replication is occurring: search? Copy?
To be checked!
What are the version of the client and the server?
Both 8.5 without fix packs. Server is RHEL 5.x Linux. client is Windows XP SP3
How much will get replicated?
The space saver is set to replicate about 4% of the documents.
How fast is the connection?
Normal ethernet 100MB
I will inform you later about the CLOCK and DEBUG settings.
Subject: Removal of deletion stubs
The database had lots of deletion stubs. Removal of the stubs was resulting in normal replication times.
Thanks all.