Problem: Slower performance encountered for particular feature classes after editing
After multiple edit sessions, an ArcSDE feature class performance degrades.
Performance is impacted when the edits of a versioned ArcSDE feature class or table accumulate and are not moved to the base table.
Registering a feature class or table as versioned creates delta tables (Adds and Deletes tables) in the database. When edits are made to the versioned feature class or table in ArcMap, the associated delta tables store the changes.
Over time, edits accumulate in the delta tables increasing the size of the database and slowing the performance.
Solution or Workaround
Compress the geodatabase to push all the records from the delta tables to the base tables. For more information, refer to the following help documentation: Geodatabase Compression
- ArcGIS Help: A quick tour of versioning
- ArcGIS Help: Replica creation and versioning
- ArcGIS Help: Working with geodatabase replicas
- ArcGIS Help: The geodatabase compress operation