Discussion Locked

Call Stored Procedure w/COM from ASP?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi all -

Quick question - I'm working on a project that uses ASP and a COM middle tier object. Instead of calling the stored procedure from SQL server directly in ASP, my predecessor elected to create a COM object which receives the request from ASP, and then makes the stored procedure call on its own, and then returns the result set to ASP.

My question is - is this really faster than calling the stored procedure from ASP? I know it's cleaner as there are fewer lines of
code involved, but is it faster?

Thanks!

Eric Doggett

1 reply

by richard

shouldn't think there is much in it. However if things get more complex, having stuff in COM objects is a better bet. Also means your could include these directly from VB etc.

This discussion is closed to new replies.