Increasing Group By performance in LINQ queries
In this section, we will look at three different ways of performing the same Group By
operation. Each way provides a different performance level. You will see by the end of this section which method is best for performing fast Group By
queries. The methods that we add in this section will be added to the LinqPerformance
class.
For our scenario, we want to get a list of people from a collection that all share the same name. To extract those people, we will perform a Group By
operation. Then, we will extract all those for whom the group count is greater than one, and then add them to a list of people.
Let us add our three methods that use the GroupBy
clause to return a list of people:
- Add the
GroupByVersion1()
method:[Benchmark] public void GroupByVersion1() { List<Person> People = _people.GroupBy(x => x.LastName) .Where(x => x...