Another post for ASP.NET developers reading this blog. If you think these posts do not belong here, please leave a comment, and I'll consider moving my development articles to a separate blog.
Here's a free optimization tip. Suppose you concatenate your SQL-command like this (don't mind the SQL-text it's just an example) :
sqlCmd.CommandText =
"SELECT hdIssues.PublishToKB, hdIssues.UserID, " +
"Issues.IssueDate,Issues.Priority, " +
"Status.Name AS Status, " +
"Users.UserName, Users.email, " +
"Performers.UserName, " +
"FROM Issues " +
"JOIN Status ON Issues.StatusID = Status.StatusID " +
"JOIN Users Users_1 ON Issues.UserID = Users_1.UserID " +
"JOIN Cats ON Issues.CategoryID = Cats.CategoryID " +
"LEFT JOIN Users ON Users.UserID = Issues.ToUserID " +
" WHERE hdIssues.InstanceID=" + Instance.GetID();
Now stop doing this and do that:
sqlCmd.CommandText =
@"SELECT Issues.PublishToKB, Issues.UserID,
Issues.IssueDate,Issues.Priority,
Status.Name AS Status,
Users.UserName, Users.email,
Users_1.UserName,
FROM hdIssues
JOIN hdStatus ON hdIssues.StatusID = Status.StatusID
JOIN hdUsers Users_1 ON hdIssues.UserID = Users_1.UserID
JOIN Cats ON Issues.CategoryID = Cats.CategoryID
LEFT JOIN Users ON hdUsers.UserID = hdIssues.ToUserID
WHERE hdIssues.InstanceID=" + Instance.GetID();
See the difference? It's the magic
@" opening quotes. That saves you 11 string concatenations still leaving your SQL-code readable.