Skip to main content
Question

ArcSDE geodatabase writer very slow during updates

  • May 7, 2019
  • 3 replies
  • 106 views
jgulmans
Contributor
Forum|alt.badge.img

While updating my sde geodatabase the writer in FME is really slow. Does anyone have expierence with speeding this up? The articles I find on performance are not enough to solve my problem.

It updates as much as 1 object per second. And I need to update 30.000 records.

It seems that the old version of the writer is working fine. However, now that I am using FME 2018.1, the writer is much slower.

 

Edit: i must use edit sessions, because of a versioned database

I hope that someone can help me!

Kind regards

Jelle

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

david_r
Celebrity
  • david_rCelebrity
  • May 7, 2019

Are you perhaps using Edit Sessions in your writer? Or regular transactions?

jgulmans
Contributor
Forum|alt.badge.img
  • jgulmansContributor
  • Author
  • Contributor
  • May 7, 2019

Are you perhaps using Edit Sessions in your writer? Or regular transactions?

Thanks for your reply. Unfortunately I am updating a versioned database. So i have to use edit sessions.

david_r
Celebrity
  • david_rCelebrity
  • May 7, 2019

Thanks for your reply. Unfortunately I am updating a versioned database. So i have to use edit sessions.

That's a known issue when using edit sessions or versioning settings on the writer, see https://knowledge.safe.com/articles/165/improving-performance-when-working-with-esri-geoda.html

I suspect this is mostly an issue related to the underlying ArcGIS libraries, not so much FME, however.

Community Stats

32,182
Posts
122,176
Replies
39,855
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
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.