INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!

Talk With Other Members
Be Notified Of Responses
To Your Posts
Keyword Search
One-Click Access To Your
Favorite Forums
Automated Signatures
On Your Posts
Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Tek-Tips LinkedIn^® Group

Join our
LinkedIn^® Group!

Hook up with past and present colleagues and classmates quickly.

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site

(Download This Button Today!)

Feedback

"...Many thanks to you for putting it together and to the forum members for taking the time to post their replies and give their time to help others. Their isn't another site that can touch it..."

More...

Geography

Where in the world do Tek-Tips members come from?

Click Here To Find Out!

Tek-Tips Shirts!

Get your
Tek-Tips Forums
SWAG here!

Home > Forums > Programmers > EAI Distributed/Component Programming > Microsoft: COM+ Forum

Comparison between Stored Procedure and MTS COM

Read More Threads Like This One

not24 (Programmer)

17 May 04 18:00

Please excuse my language. It may look a little confuse.

I know a little bit about SQL Stored Procedure and even less in MTS COM but I'm learning.

I'm implementing ASP web-based to pull data from MS SQL 2000. I have read from some website talking about ASP performance and I did found some topic that suggest try to use stored procedure as much as possible and also paging through records using a stored procedure.

I just curious that what if I create MTS COM (and clear it) 10 times in same ASP script compare with paging through records using a stored procedure (I actually didn't paging just executed stored procedure to get result and show it in ASP.) also 10 times.

- Would it make any difference in terms of server resource usage?
- How about server traffic? Would it still make a trip between IIS & SQL Server same amount of times if I still use MTS COM?
- Or should I use MTS COM instead?

Please advice,

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Back To Forum

Back To Microsoft: COM+