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

    Related Information