Concatenation of Strings LINQ vs For Loop, Where the execution will be faster ?

Question

For Loop for concatenation of strings foreach ( int id in ints) { idString. Append (id + ', ' ); } LINQ Query to concatenate a string string ids = ints . Select ( query => query . ToString ()). Aggregate (( a , b ) => a + ', ' + b ); Performance wise which one will be faster. I searched through many websites, mostly they say LINQ has some performance implications like that, is that true or above LINQ query will execute faster.

Suthish Nair · Answer

good one.. sorry for posting links... http://www.linqpad.net/WhyLINQBeatsSQL.aspx

Manikavelu Velayutham · Answer

Yes, I did all the test and finally found that LINQ is very much slower. Ordinary For Loop doing the job in 1.4657 Milliseconds. same job did through LINQ in 45.5678 Milliseconds. I have done various test in LINQ like Aggreegate, Appending Strings, Filtering Rows - Everything seems to be slower in performance. Now my question is What is the exact use or introducing LINQ concepts?

Suthish Nair · Answer

Mani, You searched many websites? The sample you given above seems same here too. http://stackoverflow.com/questions/217805/using-linq-to-concatenate-strings The site already have a good discussion about this.

Sam Hobbs · Answer

I thought that the documentation is quire clear that the StringBuilder class is more efficient than the String class when the string needs to be updated.

Mike Gold · Answer

Hi Manikavelu, You can easily test this yourself. 1) Create a large enough test sample array 2) Put the following code before and after your code DateTime start = DateTime.Now ; // code here DateTime end = DateTime.Now; TimeSpan elapsedtime = end - start; if this time is to coarse, use a hires timer http://msdn.microsoft.com/en-us/library/aa964692(VS.80).aspx

Concatenation of Strings LINQ vs For Loop, Where the execution will be faster ?

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (5)