Call Stored Procedure w/COM from ASP? - TechRepublic
General discussion
April 10, 2002 at 05:30 AM
eric.doggett

Call Stored Procedure w/COM from ASP?

by eric.doggett . Updated 24 years, 1 month ago

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

This discussion is locked

All Comments