Click here to Skip to main content

Go to Tip/Trick

A better way to count(*)

Lee Humphries

Rate me:

4.00/5 (2 votes)

7 Jun 2010CPOL

9.8K

4

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

Views

Daily Counts

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.

Comments and Discussions

Go to top