Fastest way to compare multiple column values I was recently working on a project with stored procedures that had a significant amount of column comparisons in a MERGE statement. This was turning into a real performance bottleneck (relatively speaking) as… Continue Reading
C#: Is It Faster to Preallocate Dictionary Sizes? This test will benchmark populating C# Dictionary and ConcurrentDictionary objects to determine in C#: is it faster to preallocate dictionary sizes? Or not? When a Dictionary object is created, its initial capacity… Continue Reading
Fastest Way to Compare Strings in C# .Net What is the fastest way to compare strings in C# .Net? Everyone’s had to do it. A lot of people instinctively use the C# “==” operator. In several programming forums I’ve posted… Continue Reading
Fastest Collection for String Lookups in C# .Net All C# programmers have had to do this at some point in their career… look for a particular string as some sort of key or value within a data structure. But how… Continue Reading
Faster to Trim during or after assignment in C# .Net Does it make a difference if you Trim() during or after assigning a value to a variable in C# .Net? Which was is faster? Which object, String or StringBuilder, is… Continue Reading
C#.Net: The Fastest Way to count substring occurrences in a string This will examine many techniques to determine in C# .Net: the Fastest Way to count substring occurrences in a string. Background: This test stemmed from a project where… Continue Reading
C# .Net: Fastest Way to clear Collections In this article I’ll investigate different ways to clear out commonly used Collections such as Hashsets, Dictionaries, ConcurrentDictionaries, ArrayLists, and Arrays, benchmarking the results. This will determine in C# .Net: Fastest way to… Continue Reading
Optimizing SQL Strategies How many of you have come across SQL code that, for whatever reason, wasn’t written as good as it could have been? I’m not talking about going into the inner workings of your database’s engine and milking… Continue Reading
The Fastest Way to count the number of times a character occurs in a string using C# .Net: This test stemmed from my other test on the fastest way to count the number of times a string occurs within another… Continue Reading
C# .Net: fastest way to convert an int to a string Here I am going to benchmark several techniques to find the fastest way to convert an int to a string. All C# programmers have to do this at… Continue Reading