Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-12503

SQL Server use NOCOUNT on all stored procedures

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.6.0-HF23, 5.7.2
    • Fix Version/s: 5.6.0-HF24, 5.7.3
    • Component/s: Core VCS

      Description

      By default, every time a stored procedure is executed, a message is sent from the server to the client indicating the number of rows that were affected by the stored procedure.
      By turning off this default behavior, it reduces network traffic between the server and the client.
      This can be done using SET NOCOUNT ON at the beginning of each stored procedure and trigger (not for function).
      This has already been done for few of them but not all.

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: