Timeline for Is there a performance hit from using a Feature Dataset?
Current License: CC BY-SA 3.0
8 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 29, 2011 at 4:02 | vote | accept | Stephen Lead | ||
| Jun 28, 2011 at 16:07 | comment | added | D.E.Wright | Yes, if your data is designed properly. But the problem is very true; I have this as proof positive in any of my production DBs right now. All of these Are ArcSDE 9.3.1 running on SQL2008. If you have a feature-dataset and users are reading data inside of that dataset it is locked from users being able to push more data into them unless you are built out using multipile schema's. This is a well documented issue, you can find it on the site by searching for 'ArcSDE feature dataset locking' | |
| Jun 28, 2011 at 13:56 | comment | added | Mapperz♦ | Only for Personal and File Geodatabases - SDE Geodatabase can be editing with multiple users (Enterprise - Unlimited editors, Workgroup - 10 editors and Desktop - 1 editor 3 readers.) esri.com/software/arcgis/geodatabase/… | |
| Jun 28, 2011 at 6:36 | comment | added | ujjwalesri | Thanks for the link! The reason I asked for it was because the statement The biggest kick you will have is record locking; since editing a layer in a feature dataset will close out users from making other changes there., I think is incorrect. What you might wanna say is in case of "schema edits" the dataset is "locked" to a single user, hence disabling multiple users making simultaneous changes to the schema. Record level locking would not occur! | |
| Jun 28, 2011 at 5:25 | comment | added | D.E.Wright | The Schema locking is well documented issue; to prevent changes to a dataset while changes are happening at the same time. This is a long existing issue; for the most part it is by design to maintain data integrity... help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//… Search ESRI site for Feature Dataset Locking | |
| Jun 28, 2011 at 4:27 | comment | added | ujjwalesri | Is this documented in ESRI help anywhere? Can you please post a link for the same. | |
| Jun 28, 2011 at 1:49 | comment | added | Stephen Lead | Does this mean that if you are editing, then the feature datasets are actually an advantage, since only those featureclasses within the feature dataset will be locked (without feature datasets, all featureclasses would be locked)? | |
| Jun 28, 2011 at 1:34 | history | answered | D.E.Wright | CC BY-SA 3.0 |