Skip to main content
  • EN

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

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

30,102
Posts
114,268
Replies
37,736
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.