SQL Server Performance Forum – Threads Archive
stored procedures / returning select informations
Hi, one of my stored procedures behaves poorly mostly because it returns lots of select statements results. The bad thing is I don’t need this resultsets. Is there a way to prevent SQL Server from returning select results in a stored procedure ? The option set fmtonly gives me a 30% boost, but I’d also like to not send meta informations. Thanks in advance,Thoriin
Use SET NOCOUNT ON as the first line of your procedure – in itself it already provides a performance boost, but it also suppresses the "x records" lines. Check if your client app still responds correctly after the change, before committing.
]]>