Question

Is there a way to improve FeatureWriter speed?

  • 21 July 2016
  • 1 reply
  • 2 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

1 reply

erik_jan
Rank
Userlevel 2
Badge +16

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.

Reply


Community Stats

28,716
Posts
109,494
Replies
36,561
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.