Performance Issues in MTS

[sut]

Does any body has a statistics on the performance of MTS if we call a VB component to add / update / delete a record to/from the table (or tables having average number of fields)?
I would like to know how much time and storage space MTS would take to do above transactions for an instance of a single component.

Thanks
Smita

 

[chiph]

Smita -

I don't have any actual numbers, but if you design your COM+ applications according to the Microsoft design suggestions, it's actually pretty fast. The biggest limitation is using Visual Basic 6, because it doesn't do free threading (and thus can't be pooled). For ultimate performance (until .NET comes out), you'll have to write your components in C++.

Chip H.