Sql express geodatabase "Database server" - 2 editors

Anonymous User

Hello all,

We have 2 concurrent editors here working on the same SQL Express geodatabase in ArcGIS for Desktop Standard 10.2.1. We have the data registered as versioned but we are actually both editing the Default version of the geodatabase, instead of versioned copies of the geodatabase.

We have recently been having very slow editing performance. Do you think it's because we aren't editing our own transactional version of the geodatabase?

I rebuild indexes and update database statistics through ArcCat on a daily basis, sometimes more often than that to try and speed it up.

Thanks,

JakeSkinner

Even though you are not using versions, you should compress the database.  When you register a feature class as versioned, an A & D table are created.  These tables are where the edits are stored until you perform a compress.  When the compress occurs, it moves the edits to the base table and clears out the A & D tables. 

When the database is not compressed, the A & D tables will continue to grow.  The larger the A & D tables are, the longer it will take to query these tables and retrieve the data.