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]

Hi Andrea,

Are you also compressing the database?

[Anonymous User]

Hi Jake,

Well, I wondered if I needed to? Since I'm not using versions? When I was reading about compressing it seemed like it was for versions. What do you think?

Thanks.

[JakeSkinner · Accepted solution]

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.

[Anonymous User]

That's the information that I was looking for. I appreciate the quick answer! It's working fast so far after a compress, rebuild indexes & update statistics.

Thank you!