Bug
The Object Loader works extremely slowly if the target SDE feature class is involved with many relationship classes.
| Bug ID Number | NIM070439 |
|---|---|
| Submitted | July 15, 2011 |
| Last Modified | April 2, 2025 |
| Applies to | No Product Found |
| Version found | 10.0 |
| Status | Will Not Be Addressed |
Additional Information
Loading any data will be slower with this many relationship classes and the type of messaging specified.Workaround
1. Run the following SQL queries to temporarily 'disconnect' the relationship classes, then 250K records can be loaded within 3 minutes!use sde10update sde.GDB_ITEMRELATIONSHIPS set Type = '725BADAB-3452-491B-A795-55F32D672290'where Type = '725BADAB-3452-491B-A795-55F32D67229C';-- 126 rows updated2. Change the Type values back to the original ones when the loading process has finished.use sde10update sde.GDB_ITEMRELATIONSHIPS set Type = '725BADAB-3452-491B-A795-55F32D67229C'where Type = '725BADAB-3452-491B-A795-55F32D672290';Steps to Reproduce
Bug ID: NIM070439
Software:
- No Product Found
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App