// Using concatenation operators can sometimes produce// cleaner-looking code, but performance is not as good.String begin_query = "select UPPER(MachineName) As MachineName, " + "LOWER(MachineOwner) As MachineOwner, Status, " + "StartTime from NET_STRESS WHERE ";String end_query = " AND StartTime > '" + startTime + "' AND StartTime < '" + endTime + "'";String query = begin_query + GetWhereClause("PASSED") + end_query;// Consider replacing with StringBuilder instead:StringBuilder begin_query = new StringBuilder();begin_query.Append("select UPPER(MachineName) As MachineName ");begin_query.Append("LOWER(MachineOwner) As MachineOwner, Status, ");begin_query.Append("StartTime from NET_STRESS WHERE ");StringBuilder end_query = new StringBuilder();end_query.Append(" AND StartTime > '");end_query.Append(startTime);end_query.Append("' AND StartTime < '");end_query.Append(endTime);end_query.Append("'");String query = begin_query.Append(GetWhereClause("PASSED")).Append(end_query).ToString();' Using concatenation operators can sometimes produce' cleaner-looking code, but performance is not as good.Dim begin_query As String = "select UPPER(MachineName) As MachineName, " _ & "LOWER(MachineOwner) As MachineOwner, Status, " _ & "StartTime from NET_STRESS WHERE "Dim end_query As String = " AND StartTime > '" & startTime & "' AND StartTime < '" & endTime & "'"Dim query As String = begin_query & GetWhereClause("PASSED") & end_query' Consider replacing with StringBuilder instead:Dim begin_query As New StringBuilderbegin_query.Append("select UPPER(MachineName) As MachineName ")begin_query.Append("LOWER(MachineOwner) As MachineOwner, Status, ")begin_query.Append("StartTime from NET_STRESS WHERE ")Dim end_query As New StringBuilderend_query.Append(" AND StartTime > '")end_query.Append(startTime)end_query.Append("' AND StartTime < '")end_query.Append(endTime)end_query.Append("'")Dim query As String = begin_query.Append(GetWhereClause("PASSED")).Append(end_query).ToString()// Using concatenation operators can sometimes produce// cleaner-looking code, but performance is not as good.var begin_query:String = "select UPPER(MachineName) As MachineName, " + "LOWER(MachineOwner) As MachineOwner, Status, " + "StartTime from NET_STRESS WHERE ";var end_query:String = " AND StartTime > '" + startTime + "' AND StartTime < '" + endTime + "'";var query:String = begin_query + GetWhereClause("PASSED") + end_query;// Consider replacing with StringBuilder instead:var begin_query:StringBuilder = new StringBuilder();begin_query.Append("select UPPER(MachineName) As MachineName ");begin_query.Append("LOWER(MachineOwner) As MachineOwner, Status, ");begin_query.Append("StartTime from NET_STRESS WHERE ");var end_query:StringBuilder = new StringBuilder();end_query.Append(" AND StartTime > '");end_query.Append(startTime);end_query.Append("' AND StartTime < '");end_query.Append(endTime);end_query.Append("'");var query:String = begin_query.Append(GetWhereClause("PASSED")).Append(end_query).ToString(); |