
Why to use COM+ transaction and not just SQL Server transaction
Quote:
> Hi,
> I am developing a large ecommerece web site using Business logic in
activeX
> dll and SQL Server 7 database. I read all this articles about the
> transaction support in COM+ however it seems to me like a huge overhead.
> Since I am using sp like everyone. why would I benefit from using
compoenets
> transactions and not just use transation support is my sp.
> I understand the components transaction make the code more modular nad
> scalable but does it worth the overhead in performance?
> I'll be happy if you could give me more reference about this subject
In addition to what others mentioned, COM+/MTS transactions are extremely
useful if you want to have one component make calls to other components and
have it all within a single transaction. Doing this yourself with SQL
transactions would mean passing around a Connection object and keeping track
of everything yourself. Why not let the COM+ runtime do this for you.
If you have simple components where each transaction is fully contained in a
single object method, you can probably get by with just SQL Server
transactions. Once things get more complex it just makes sense to take
advantage of the COM+ services.
Jeff