Strange problem: the commandtext watermark value of sqlcommand causes poor performance

Source: Internet
Author: User

Recently, when I was doing a batch of data processing performance tuning, I found that the typical audit login and audit logout are not found in sqlprofiler, if the commandtext comment value of the command sentence is not logged out before the update or add operation of the latest row data, if the threshold value is later, logout will be generated. I do not know why. The performance deviation may reach 15%-20%.

If the explain method is as follows:
Create a consumer connected to conn;
Sqlcommand comm = new sqlcommand (conn );
Sqlparameter Param;
String strsql = "Update Table1 set name = @ name"
Comm. commandtext = strsql; // note: the limit value of this sentence is before parameter.
Param. parametername = "@ name ";
Param. value = "value ";
Comm. Parameters. Add (PARAM );
Comm. executenonquery ();
Conn. Close ();

If the explain method is as follows:
Sqlcommand comm = new sqlcommand (conn );
Sqlparameter Param = new sqlparameter ();
String strsql = "Update Table1 set name = @ name"
Param. parametername = "@ name ";
Param. value = "value ";
Comm. Parameters. Add (PARAM );
Comm. commandtext = strsql; // Note: This sentence is after the parameter value parameters.
Comm. executenonquery ();
Conn. Close (); // number of rows connected to logout

 

 

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.