Yes I will put together a more comprehensive set of comparisons. I want to
make some changes to the way the current queue is setup based on the earlier
suggestions, allowing the use of the same db for service broker and
transactional store and remove the auto-creation etc.
Another thing to consider for this is whether or not using the
System.Transaction + SqlTransaction for both scenarios of a
System.Transaction that is promoted to DTC and not. I have run tests some
time ago that indicated that using SQL transactions combined with
System.Transaction provided the best performance over relying on the
sqlconnections enlistment. There is likely documentation somewhere on this,
but it would probably be nice to see the difference when using it within
RSB.
begin systemtransaction
open connection
begin sqltransaction
commit sqltransaction
close connection
commit systemtransaction
vs.
begin systemtransaction
open connection
//connection is auto-enlisted
close connection
commit systemtransaction
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Rhino Tools Dev" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/rhino-tools-dev?hl=en
-~----------~----~----~----~------~----~------~--~---
