Kristin Lauman 4.Jun.09 12:04 PM a Web browser Applications Development 6.5.5 FP2 Windows 2003
I've inherited a suite of 20 databases which provide weekly financials. The application is replicated to a cluster server. The databases are informational only, they are not modified by users.
A weekly scheduled agent deletes all existing documents. Then a scheduled compaction runs. After that, another scheduled agent imports new financials and parses them into the databases.
The databases are small, but there can be 275,000 docs added per database. Deletion stubs are currently purged every 15 days, so there can be up to 750,000 stubs on a database. Replication can be problematic and time consuming.
Currently, I disable replication while the scheduled agents run, then enable it again.
I'm debating using an agent to delete and recreate the cluster replicas, instead of replicating them. Would that be less efficient or more efficient than using the replicator to update the data?