I have a customer that with an application consisting of 14 databases that are replicated daily. We are finding that 2 of the databases always have very long “searching” steps. Both are fairly large (117,000 and 168,000) documents. The amount if daily updates is around 2000 for one and 5000 documents for the other. There are other databases with similar characteristics (580,000 documents with 6000-8000 updates and 68,000 documents with 3000 updates) that have fairly short searching steps.
I am looking for differences but, can’t seem to find anything in the databases. Can there be a client or server related setting that affects this?
Thanks in advance,
Dieter
Subject: Long Replication
Is selective replication used in this database? Or has it ever been used? I have found that when selective replication formulas are set up in a database, it is often the case that you will find duplicate selective replication formula notes if you examine the database with Notespeek. (I believe that these duplicate formula notes are caused by users or administrators opening up the selective replication settings and clicking OK instead of Cancel – possibly only in certain versions of the Notes client.) I have seen that when these duplicate replication formula notes exist in a database, replication will sometimes be very slow. I recommend checking the databases with Notespeek to see if you see the same thing.