Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • Transformers
  • 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

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


Community Stats

30,176
Posts
114,542
Replies
37,835
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.