All editors reconcile and post their versions daily. Other users create read-only versions for analysis purposes, so they do not reconcile and post those versions. The geodatabase administrator compresses the geodatabase nightly. For several months, performance steadily worsens.
Which action should be taken?
Scenario Overview:
Editors reconcile and post daily, but read-only versions created for analysis are not reconciled or posted.
The geodatabase is compressed nightly, but performance continues to degrade.
Cause of the Problem:
Unreconciled versions, including read-only ones, persist in the state tree, preventing the geodatabase compression from fully collapsing unused states.
Over time, this results in a bloated state tree and worsened performance.
Solution:
Reconciling and posting the read-only versions ensures that the state tree is cleared of unnecessary versions, enabling compression to collapse the database to its optimal state.
(ArcGIS Documentation: Reconcile and Post)
Alternative Options:
Option B: Creating a database view provides a read-only representation of data but does not address the underlying issue of unresolved states in the state tree.
Option C: Disabling editor tracking is unrelated to state tree performance issues and has no impact on the reconciliation or compression processes.
Therefore, reconciling the read-only versions will significantly improve performance.
Currently there are no comments in this discussion, be the first to comment!