
ADO Connection Transaction vs. ObjectContext Transaction
Quote:
> Right now my VB component only uses Cnn.transaction and declare as
> "NotAnMTSObject". I am running this component in Com+ environment.
Of course that is another option you can use... ;-)
Quote:
> If I switch to use ObjectContext trans and declare as "Required Trans",
> will the performance suffer because the overhead of ObjectContext Transaction?
Good question! I don't have actual performance numbers between the two. May be
someone else in this newsgroup can provide these...
IMHO - For applications that need to scale, you should use the COM+ ObjectContext
Transactions. For small applications, the Connection Transactions can actually be faster
than the COM+ Transaction.
You might want to ask this question over in the COM+ newsgroup.
microsoft.public.platformsdk.complus_mts
--
Thanks,
Carl Prothman
Microsoft Visual Basic MVP
http://www.able-consulting.com