A better way to count(*)

Lee Humphries

Rate me:

4.00/5 (2 votes)

7 Jun 2010CPOL

9.7K

LINQ translates .count() to a SQL query that uses COUNT(*), but on large tables even count(*) can be too slow. Here's another way

No downloads associated with this content

By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.

If a file you wish to view isn't highlighted, and is a text file (not binary), please let us know and we'll add colourisation support for it.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Written By

Lee Humphries

Founder md8n

Timor-Leste

If it ain't broke - that can be arranged.