Best way to deal with large data sources in a SDE

bdoherty

Our company has a large SDE with hundreds of datasets in it that span several Western provinces.  I generally work with 10-20 of these data sets, so I built a template that has those in it clipped to a reasonalble size area, but it is very slow to load.  This method creates 2 problems, large files sizes, and I cannot move the template to another area.  I thought using the Map catalog would fix this, but I cannot seem to add data to it from the SDE.  Is there a better way to do this ?   Ideally, I want to load 1 or 2 layers for entire province so I can navigate to an area of interset, then I want to load 20 layers from the SDE for that smaller area of intrest.