It’s not the count.
It’s locking + metadata access.
Reality
COUNT must respect:
-
Isolation level
-
Pending writes
-
Allocation metadata
Production alternative
Use approximate counts for dashboards.
Why
Accuracy isn’t always worth blocking.
Bits of .NET
Daily micro-tips for C#, SQL, performance, and scalable backend engineering.