I am currently working with large amounts of forest data where surveyors and ecologists measure and assess the quality of the vegetation in the field and send the result as CAD files on a daily basis to be converted, edited and stored in a large enterprise geodatabase. It's a rather large project with many people involved.
Even though I've created basemap layers from layers that do not need to be snapped against, it's slow to work. I know that in some CAD software (I only know the basics of CAD), you can load just a small extent of data from a database into the view and work only with that extent without having to render the entire database, but is it possible to do the same thing in ArcMap?
I've tested a lot of workarounds, clipped data to a file-based geodatabase, for example, and then copied the objects to the enterprise database after editing, but it gives a rather clumsy workflow.
If I define the spatial extent in the data frame, is it still working on the entire database? I'm not experiencing improved performance when doing so.
The optimum would have been to open an MXD with a WMS background map, draw a rectangle and load data from the database within the extent from the rectangle but I assume that ArcMap isn't built to work that way?
So, what is the easiest way to work with a small spatial extent of a large dataset?