Skip to main content
  • EN

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

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

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.

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.

Reply


Community Stats

29,729
Posts
112,949
Replies
37,369
Members
Terms & ConditionsCookie settings