Question
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
+51- Celebrity
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
hkingsbury wrote:
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
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.