Skip to main content
Question

Is there a way to improve FeatureWriter speed?

  • July 21, 2016
  • 1 reply
  • 9 views
D

I have been testing out the featurewriter transformer to handle data updates, however I have noticed that it is much slower than the equivalent standalone writer. For example, I am trying to write 80000 records to a SQL Server Spatial database table using the featurewriter. This task takes just over a minute (1:27) with the SQL Server Spatial Writer and over 10 minutes with the featurewriter transformer. The parameters are identical with the exception of those that you are not able to set with the transformer (bulk insert, tranaction interval, timeout, etc.). Is this just a flaw of the featurewriter or are there ways to improve the performance of this transformer that I have not implemented?

Thanks

This post is closed to further activity.
It may be a question with a best answer, an implemented idea, or just a post needing no comment.
If you have a follow-up or related question, 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.

1 reply

erik_jan
Contributor
Forum|alt.badge.img+22
  • erik_janContributor
  • Contributor
  • July 21, 2016

I do not know if this works the same, but I would try setting up a dummy SQL Server Spatial writer (with no feature types to write to) and set the parameters on that.

I know you can influence the Generic writer that way.

I hope that would work for the FeatureWriter as well.

It is worth the try.

Helpful Members This Week

Community Stats

31,844
Posts
120,943
Replies
39,474
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.