Call Stored Procedure w/COM from ASP?

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