Building String

• dreamslogic

  Ten Centuries

  Points: 1131

  More actions

  June 13, 2009 at 7:41 pm

  #206259

  I am building a string for a series of smaller strings. Which option is more efficient ?

  Build the string using the & Operator

  Build the string using the StringBuilder Object

  Build the string using StringCreator Object

  Build the string using the += Operator

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737630

  More actions

  June 13, 2009 at 9:43 pm

  #1009226

  These look like C# of VB.NET questions, not SQL Server.

  You can test these, write a loop to build 10,000 of each one, look at the cost/time of each.

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  June 13, 2009 at 10:00 pm

  #1009232

  Like Steve said, this may be better suited for the .Net forums, but just like everything. It depends. I rarely use StringBuilder when I code. I only use it when I have a lot of concatenation to do. I don't think there is any difference between + and & other than syntax.

  This article has some good guidelines.

  http://www.yoda.arachsys.com/csharp/stringbuilder.html

• dreamslogic

  Ten Centuries

  Points: 1131

  More actions

  June 13, 2009 at 10:40 pm

  #1009240

  Thanks for the article Ken it was really helpful.