Hi,
We're in the midst of restructuring our SDE Schema and have been asked by our IT department to remove feature classes that do not participate in a Topology out of their current Feature Dataset, as it is affecting the performance of the database, especially when editing.
Can anyone help quantify what the perfomance increase we can expect to see once we move the dataclasses out, and they essentially become stand-alone feature classes?
The current Datasets not only contain Topology, but are also used to group similar feature classes together to make things easier to find in the Catalog.
Based on my experience, I've seen no noticeable difference in the performance and I've never really noticed if there was any difference. And although feature datasets are convenient to group similar featureclass (much like data folders) you actually lose a bit of functionality when it is used this way. Example: Editing a single featureclass in the dataset will lock everything in the dataset....