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

30,108
Posts
114,295
Replies
37,744
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.