I have an arcsde geodatabase version 10.2 in SQL server express with 2 large geometric networks that runs extremely slow when I try to edit. I've talked to support about it and they said that SQL server express is limited in the amount of memory it tasks to a user and that could be slowing down the editing. I'm the only editor of our database so if I could maintain a copy of our database on my PC, and upload changes to the server as needed it should speed up edits considerably. Is there a way to do that efficiently using distributed databases? or a model that automatically uploads changes at night.
Thanks for any advice,