DZone
Thanks for visiting DZone today,
Edit Profile
  • Manage Email Subscriptions
  • How to Post to DZone
  • Article Submission Guidelines
Sign Out View Profile
  • Post an Article
  • Manage My Drafts
Over 2 million developers have joined DZone.
Log In / Join
Refcards Trend Reports
Events Video Library
Over 2 million developers have joined DZone. Join Today! Thanks for visiting DZone today,
Edit Profile Manage Email Subscriptions Moderation Admin Console How to Post to DZone Article Submission Guidelines
View Profile
Sign Out
Refcards
Trend Reports
Events
View Events Video Library
Zones
Culture and Methodologies Agile Career Development Methodologies Team Management
Data Engineering AI/ML Big Data Data Databases IoT
Software Design and Architecture Cloud Architecture Containers Integration Microservices Performance Security
Coding Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks
Culture and Methodologies
Agile Career Development Methodologies Team Management
Data Engineering
AI/ML Big Data Data Databases IoT
Software Design and Architecture
Cloud Architecture Containers Integration Microservices Performance Security
Coding
Frameworks Java JavaScript Languages Tools
Testing, Deployment, and Maintenance
Deployment DevOps and CI/CD Maintenance Monitoring and Observability Testing, Tools, and Frameworks

Integrating PostgreSQL Databases with ANF: Join this workshop to learn how to create a PostgreSQL server using Instaclustr’s managed service

Mobile Database Essentials: Assess data needs, storage requirements, and more when leveraging databases for cloud and edge applications.

Monitoring and Observability for LLMs: Datadog and Google Cloud discuss how to achieve optimal AI model performance.

Automated Testing: The latest on architecture, TDD, and the benefits of AI and low-code tools.

Related

  • Challenges of Creating Digital Twins in the Transition to Industry 4.0
  • [CSF] OfficeFloor: Going Beyond Dependency Injection
  • How to Install Runtime Fabric in Linux 7.8 (localhost)
  • Logging and Tracing for Fun and Profit: C++ Edition

Trending

  • Continuous Integration vs. Continuous Deployment
  • Resistance to Agile Transformations
  • Top 7 Best Practices DevSecOps Team Must Implement in the CI/CD Process
  • Is OpenJDK Just a Drop-In Replacement?
  1. DZone
  2. Coding
  3. Languages
  4. Linq performance with Count() and Any()

Linq performance with Count() and Any()

Jalpesh Vadgama user avatar by
Jalpesh Vadgama
·
Jan. 21, 13 · Interview
Like (0)
Save
Tweet
Share
23.81K Views

Join the DZone community and get the full member experience.

Join For Free
Recently I was using resharper to refactor some of my code and found that it was suggesting to use any() extension method instead of count() method in List<T>. I was really keen about performance and found that resharper was right. There is huge performance difference between any() and count() if you are using count() just to check whether list is empty or not.

Difference between Count() and Any():

In Count() method code will traverse all the list and get total number of objects in list while in Any() will return after examining first element in the sequence. So in list where we have many object it will be significant execution time if we use count().

Example:

Let’s take an example to illustrate this scenario. Following is a code for that.
using System;
using System.Collections.Generic;
using System.Diagnostics;
using System.Linq;
 
namespace ConsoleApplication3
{
    class Program
    {
        static void Main() {
 
            //Creating List of customers
            List<Customer> customers = new List<Customer>();
            for (int i = 0; i <= 100; i++) {
                Customer customer = new Customer {
                    CustomerId = i,
                    CustomerName = string.Format("Customer{0}", i)
                };
                customers.Add(customer);
            }
 
            //Measuring time with count
            Stopwatch stopWatch = new Stopwatch();
            stopWatch.Start();
            if (customers.Count > 0) {
                Console.WriteLine("Customer list is not empty with count");
            }
            stopWatch.Stop();
            Console.WriteLine("Time consumed with count: {0}", stopWatch.Elapsed);
 
            //Measuring time with any
            stopWatch.Restart();
            if (customers.Any()) {
                Console.WriteLine("Customer list is not empty with any");
            }
            stopWatch.Stop();
            Console.WriteLine("Time consumed with count: {0}", stopWatch.Elapsed);
        }
    }
 
    public class Customer
    {
        public int CustomerId { get; set; }
        public string CustomerName { get; set; }
    }
}

Here in the above code you can see that I created ‘Customer’ class which has simple two properties ‘CustomerId’ and ‘CustomerName’. Then in Main method I have created a list of customers and used for loop and object intializer to fill customers list. After that I have written a code to measure time for count and any with ‘Stop watch’ class and printing CPU ticks. It’s pretty simple.

Now let’s run this console application to see output.

Performance diffrence between Any() and Count() in c#

Conclusion:

Here in the above example you can see there is huge performance benefit of using any() instead of count() when we are checking whether list<T> is empty or not.

Hope you like it. Stay tuned for more...

Extension method Object (computer science) application Printing Console (video game CLI) Execution (computing) IT Measure (physics)

Published at DZone with permission of Jalpesh Vadgama, DZone MVB. See the original article here.

Opinions expressed by DZone contributors are their own.

Related

  • Challenges of Creating Digital Twins in the Transition to Industry 4.0
  • [CSF] OfficeFloor: Going Beyond Dependency Injection
  • How to Install Runtime Fabric in Linux 7.8 (localhost)
  • Logging and Tracing for Fun and Profit: C++ Edition

Comments

Partner Resources

X

ABOUT US

  • About DZone
  • Send feedback
  • Careers
  • Sitemap

ADVERTISE

  • Advertise with DZone

CONTRIBUTE ON DZONE

  • Article Submission Guidelines
  • Become a Contributor
  • Visit the Writers' Zone

LEGAL

  • Terms of Service
  • Privacy Policy

CONTACT US

  • 3343 Perimeter Hill Drive
  • Suite 100
  • Nashville, TN 37211
  • support@dzone.com

Let's be friends: