Rhino ETL: MultiThreadedBranchingOperation is causing Timeout exceptions

[jalchr]

I suspect this might lead to transaction dead lock for updates/inserts into a database:

I have this config:

new Multi-threadedBranching().

    .Left(new InsertRecords())

    .Right(new UpdateRecords())

since the process is transactional, and the two operations might run simultaneously on different trhead, this will be cause one operation to timeout waiting for the second to complete (which it won't until whole process finishes)

I think SQL locks the table for updates when in transactional mode.

Any one got similar results ?

[Miles Waller]

Are you using a bulk insert task? This is likely to use table locks for performance, but there is an option to downgrade to rowlocks that might help.

I dont know whether the rhino operation exposes this though.

Miles

--
You received this message because you are subscribed to the Google Groups "Rhino Tools Dev" group.
To view this discussion on the web visit https://groups.google.com/d/msg/rhino-tools-dev/-/WQZnL1bnQ8MJ.
To post to this group, send email to rhino-t...@googlegroups.com.
To unsubscribe from this group, send email to rhino-tools-d...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/rhino-tools-dev?hl=en.

[jalchr]

It turned out that the updated table didn't have a primary key index which resulted in timeouts (don't know why actually) ...

Once the index was there ... the timeout exception went away