SQL Server Performance

stored procedures / returning select informations

Discussion in 'T-SQL Performance Tuning for Developers' started by thoriin, Jan 13, 2005.

  1. thoriin New Member

    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
  2. Adriaan New Member

    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.

Share This Page