-
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
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.