[dba-SQLServer] Executing SP's

Species 2175 accessdsql at yahoo.com
Thu Mar 16 09:08:40 CST 2006


hi group,

I'm using SQL Server 2000.
I've developed an application that uses a lot of sp's.
To make this easy for the FE created 4 stored procedures that call 15-35 other sp's.

e.g.:
create stored proc usp_DoSomething
as
begin
exec usp_DoSomething1
exec usp_DoSomething2
exec usp_DoSomething3
exec usp_DoSomething4
end

Is there a performance penalty for this way of working?
Eg in stead of calling/executing each sp on it's own?

Regards,

Sander

		
---------------------------------
 Yahoo! Mail
 Use Photomail to share photos without annoying attachments.


More information about the dba-SQLServer mailing list