Using the Esri Geodatabase (ArcSDE Geodb) Reader and Writer what would be the best settings to get the best performance to truncate and insert annotation feature class records to a writer. These annotation feature classes are not versioned
Using the Esri Geodatabase (ArcSDE Geodb) Reader and Writer what would be the best settings to get the best performance to truncate and insert annotation feature class records to a writer. These annotation feature classes are not versioned
Userlevel 5
+29
- Celebrity
- 1109 replies
-
4 November 2021
I've found for absolute best performance with SDE is to write directly to the underlying database (eg SQL) completely bypassing the SDE layer.
This of course comes with limitations and risks and depends on how you environment is setup
I've found for absolute best performance with SDE is to write directly to the underlying database (eg SQL) completely bypassing the SDE layer.
This of course comes with limitations and risks and depends on how you environment is setup
This would be going from an Oracle to SQL server database. I wasn't sure if the Oracle SHAPE columns (Shape, Length, etc...) would equal to the SQL Server Shape Columns.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.