Skip to main content
Question

commit after writter


Good morning,

I have a question about FME

I have many readers and writers that transform files into oracle tables, and he reads everyone and does commit only after all. I would like you to conduct a commit every transaction from reader to writer

2 replies

davideagle
Contributor
Forum|alt.badge.img+21
  • Contributor
  • June 8, 2018

On your Oracle writer there's a Parameter called 'Features Per Transaction'. This parameter specifies how many features are written to the database before they are committed. It is usually a multiple of Bulk Write Size. It is possible to set this value to 1 but, it's likely to introduce a performance hit on you write speed.


davideagle wrote:

On your Oracle writer there's a Parameter called 'Features Per Transaction'. This parameter specifies how many features are written to the database before they are committed. It is usually a multiple of Bulk Write Size. It is possible to set this value to 1 but, it's likely to introduce a performance hit on you write speed.

 

Nice... Is it possible, my second reader, to recognize the data of the first writer? I did the test, the first attempt was made the first writer, the second reader did not recognize. But when I ran the FME again, he recognized it. I would like this interaction in the first run. It's possible?

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