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

Revisions

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.