Performance issue in editing SQL feature class that contains 250,000 records

Question

Hi All,

We are wondering how to improve the performance in editing SQL feature class of 250,000 records that contains 250,000 records. It appears that compress, rebuild and analyze don’t help that much in enhancing the editing considerably. Editing is really slow at the moment!

Best,

Rawan

rawansaleh1 · Answer

Thanks all for the answers.

Dear Quinn,

Thank you for your answer, kindly see the following:

* we use SQL 2016
* ArcMap 10.4.1
* we use a local network ,so that the database server machine is different from the client .
* we use polygon feature class
* the performance issue strictly limited to editing operations & the panning/zooming slow.
* we always have witnessed latency
* we haven’t faced the following: architectural changes, DBMS Upgrade, Moving data to a new server.
* the feature class registered as versioned.
* actually we sometimes compress and rebuild  the database.
* the performance is witnessed on this single feature class.

So, what might be the issue here?

Thanks in advance

Rawan

WilliamSchoefmann · Answer

Sounds like you might need to do some tuning on the back end of your SQL database, if you're using SQL express remember there's only a 10gb per database max and even less for earlier versions.  Some of the questions Quinn asked would be helpful to pin point the problem.

JoshuaBixby · Answer

https://community.esri.com/groups/geodatabase?sr=search&searchId=6c227198-2550-4fb8-871b-de09f065ea68&searchIndex=0‌