Solved

SUPER SLOW Reading with SDE Writer

  • 2 February 2018
  • 1 reply
  • 11 views

Badge +8

When playing around with FME 2017 today on a new project, we noticed that attaching an sde writer to a workflow dramatically slows down the reader. Has anyone else noticed this issue occur? Worth noting is that we aren't using versioning or transactions (transaction type = 'none') and the only reason we are using the GEODATABASE_SDE writer is because we need to write esri's ST geometry.

Writing to Inspector: FME Session Duration: 16.5 seconds. (CPU: 11.1s user, 1.6s system)

Writing to SDE: FME Session Duration: 2 minutes 6.0 seconds. (CPU: 51.0s user, 2.5s system)

Since Oracle writers work fast and all we need is the esri ST geometry type, we were thinking about trying to hack together a solution where we could trick FME into writing the point geometry out in the expected format ie: SDE.ST_GEOMETRY(1,1,-10106993.68204,5190612.4770125,-10106993.68204,5190612.4770125,0,0,NULL,NULL,0,0,300041,(BLOB))

icon

Best answer by trentatsafe 6 February 2018, 19:55

View original

1 reply

Badge +6

Hello @runneals,

 

 

I was able to reproduce your results and have filed a PR on your behalf. PR81964 related to the ArcSDE Geodb writing performance issue that you have found. I will update this posting with any updates/fixes as I hear from development.

 

 

In the meantime, you may be able to use the ArcSDE Legacy writer. I believe it has superior performance, but it does lack some of the advanced functionality that the primary writer offers. You can see the differences between the two in this article: https://knowledge.safe.com/articles/19440/comparison-of-fme-readers-and-writers-for-sde-and.html

Reply